Property | Value |
---|---|
SQL Server Version | SQL Server 2016 |
Compatibility Level | SQL Server 2016 |
Last backup time | - |
Last log backup time | - |
Creation date | Mar 21 2019 |
Users | 4 |
Database Encryption Enabled | False |
Database Encryption Algorithm | None |
Database size | 16.00 MB |
Unallocated space | 4.22 MB |
Property | Value |
---|---|
Compatibility Level | 130 |
Database collation | SQL_Latin1_General_CP1_CI_AS |
Restrict access | MULTI_USER |
Is read-only | False |
Auto close | False |
Auto shrink | False |
Database status | ONLINE |
In standby | False |
Cleanly shutdown | False |
Supplemental logging enabled | False |
Snapshot isolation state | OFF |
Read committed snapshot on | False |
Recovery model | FULL |
Page verify option | CHECKSUM |
Auto create statistics | True |
Auto update statistics | True |
Auto update statistics asynchronously | False |
ANSI NULL default | False |
ANSI NULL enabled | False |
ANSI padding enabled | False |
ANSI warnings enabled | False |
Arithmetic abort enabled | False |
Concatenating NULL yields NULL | False |
Numeric roundabort enabled | False |
Quoted Identifier On | False |
Recursive triggers enabled | False |
Close cursors on commit | False |
Local cursors by default | False |
Fulltext enabled | True |
Trustworthy | False |
Database chaining | False |
Forced parameterization | False |
Master key encrypted by server | False |
Published | False |
Subscribed | False |
Merge published | False |
Is distribution database | False |
Sync with backup | False |
Service broker GUID | f8eb2cdb-8ccf-40cf-b4ed-a07a6afe0119 |
Service broker enabled | False |
Log reuse wait | NOTHING |
Date correlation | False |
CDC enabled | False |
Encrypted | False |
Honor broker priority | False |
Default language | English |
Default fulltext language LCID | 1033 |
Nested triggers enabled | True |
Transform noise words | False |
Two-digit year cutoff | 2049 |
Containment | NONE |
Target recovery time | 60 |
Database owner | ceojuice |
Name | Type | Size | Maxsize | Autogrowth | File Name |
---|---|---|---|---|---|
fmacentral_4_3_72 | Data | 8.00 MB | unlimited | 64.00 MB | C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\fmacentral_4_3_72.mdf |
fmacentral_4_3_72_log | Log | 8.00 MB | 2048.00 GB | 64.00 MB | C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\fmacentral_4_3_72_log.ldf |