Database: AdventureWorks2008

Properties

Property Value
Database Name AdventureWorks2008
Database Id 12
Description AdventureWorks2008 Sample OLTP Database update
Owner PROJECTENVISION\Administrator
Owner SID x01050000000000051500000025B2C65A6DE3BF7F151D61F3F4010000
Compatibility Level 100
Structure Version 655
Creation Date 8/8/2010 5:21:02 PM
Collation Name SQL_Latin1_General_CP1_CI_AS
State ONLINE
User Access MULTI USER
Recovery Model SIMPLE
Page Verification Option CHECKSUM
Read Only false
Auto Close false
Auto Shrink false
Is Standby false
Fulltext Enabled true
Trustworthy false
DB Chaining false
Forced Parameterization false
Change Data Capture Enabled false
Date Correlation false

Database Options

Option Value
Auto Create Stats true
Auto Update Stats true
Auto Update Stats Async false
ANSI Null Default On false
ANSI Null On true
ANSI Padding On true
Quoted Identifier true
Concat Null Yields Null true
ANSI Warnings On true
Arithmetic Abort true
Numeric Round Abort false
Recursive Triggers false
Cursor Close On Commit false
Is Local Cursor Default false

Database Encryption

Option Value
Master Key Encrypted By Server true
Is Encrypted false

Database Replication

Option Value
Is Published false
Is Subscribed false
Is Distributor false
Sync With Backup false

Database Snapshots

Option Value
Snapshot Isolation State OFF
Supplemential Logging Enabled false
Is Read Committed Snapshot false

Service Broker

Option Value
Service Broker Guid 1417c7e4-2945-43f3-b388-05f5406555d0
Broker Enabled true
Broker Priority Honored false

Space Used

Property Value
Database Size 227.00 MB
Unallocated Space 24.10 MB
Reserved 184.9 MB
Data Space Reserved and Used 95.91 MB
Index Spaced Used 82.19 MB
Unused Space 6.8 MB

Filegroups

Data Space Id Name Type Default Is Read Only Extended Property Name Extended Property Value
2 DocumentFileStreamGroup FILESTREAM DATA FILEGROUP true false
1 PRIMARY ROWS FILEGROUP true false MS_Description Primary filegroup for the AdventureWorks2008 sample database. mobi update
3 test1fg ROWS FILEGROUP false false MS_Description aaaa
4 test2fg ROWS FILEGROUP false false
5 test3fg ROWS FILEGROUP false false
6 test4fg ROWS FILEGROUP false false

Data Files

Filegroup File Id Name Size Max Size Growth Usage Filename Extended Property Name Extended Property Value
PRIMARY 1 AdventureWorks2008_Data 195 MB Unlimited 16 MB data only C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008_Data.mdf MS_Description Primary data file for the AdventureWorks2008 sample database. mobi update
test1fg 3 test1fg 5 MB Unlimited 1 MB data only C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\test1fg.ndf MS_Description aaa
test2fg 4 test2fg 3 MB Unlimited 1 MB data only C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\test2fg.ndf MS_Description aaaa
test3fg 5 test3fg 3 MB Unlimited 1 MB data only C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\test3fg.ndf
test4fg 6 test4fg 3 MB Unlimited 1 MB data only C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\test4fg.ndf

Transactional Log Files

File Id Name Size Max Size Growth Usage Filename
2 AdventureWorks2008_Log 18 MB 2097152 MB 16 MB log only C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008_Log.ldf