Database fmacentral_4_3_72 Database
PropertyValue
SQL Server VersionSQL Server 2016
Compatibility LevelSQL Server 2016
Last backup time-
Last log backup time-
Creation dateMar 21 2019
Users4
Database Encryption EnabledFalse
Database Encryption AlgorithmNone
Database size16.00 MB
Unallocated space4.22 MB
PropertyValue
Compatibility Level130
Database collationSQL_Latin1_General_CP1_CI_AS
Restrict accessMULTI_USER
Is read-onlyFalse
Auto closeFalse
Auto shrinkFalse
Database statusONLINE
In standbyFalse
Cleanly shutdownFalse
Supplemental logging enabledFalse
Snapshot isolation stateOFF
Read committed snapshot onFalse
Recovery modelFULL
Page verify optionCHECKSUM
Auto create statisticsTrue
Auto update statisticsTrue
Auto update statistics asynchronouslyFalse
ANSI NULL defaultFalse
ANSI NULL enabledFalse
ANSI padding enabledFalse
ANSI warnings enabledFalse
Arithmetic abort enabledFalse
Concatenating NULL yields NULLFalse
Numeric roundabort enabledFalse
Quoted Identifier OnFalse
Recursive triggers enabledFalse
Close cursors on commitFalse
Local cursors by defaultFalse
Fulltext enabledTrue
TrustworthyFalse
Database chainingFalse
Forced parameterizationFalse
Master key encrypted by serverFalse
PublishedFalse
SubscribedFalse
Merge publishedFalse
Is distribution databaseFalse
Sync with backupFalse
Service broker GUIDf8eb2cdb-8ccf-40cf-b4ed-a07a6afe0119
Service broker enabledFalse
Log reuse waitNOTHING
Date correlationFalse
CDC enabledFalse
EncryptedFalse
Honor broker priorityFalse
Default languageEnglish
Default fulltext language LCID1033
Nested triggers enabledTrue
Transform noise wordsFalse
Two-digit year cutoff2049
ContainmentNONE
Target recovery time60
Database ownerceojuice
NameTypeSizeMaxsizeAutogrowthFile Name
fmacentral_4_3_72Data8.00 MBunlimited64.00 MBC:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\fmacentral_4_3_72.mdf
fmacentral_4_3_72_logLog8.00 MB2048.00 GB64.00 MBC:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\fmacentral_4_3_72_log.ldf