Database CoSystem Database
PropertyValue
SQL Server VersionSQL Server 2016
Compatibility LevelSQL Server 2016
Last backup time-
Last log backup time-
Creation dateMay  9 2018
Users6
Database Encryption EnabledFalse
Database Encryption AlgorithmNone
Database size208.00 MB
Unallocated space93.61 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 modelSIMPLE
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 GUIDd41cec5e-7b58-4671-8df6-bc53dc63f0ca
Service broker enabledTrue
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
NameTypeSizeMaxsizeAutogrowthFile Name
CoSystemData136.00 MBunlimited64.00 MBC:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\CoSystem.mdf
CoSystem_logLog72.00 MB2048.00 GB64.00 MBC:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\CoSystem_log.ldf