# 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 |
Auto Close |
Auto Shrink |
Is Standby |
Fulltext Enabled |
Trustworthy |
DB Chaining |
Forced Parameterization |
Change Data Capture Enabled |
Date Correlation |

## Database Options

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

## Database Encryption

Option | Value
--- | ---
Master Key Encrypted By Server |
Is Encrypted |

## Database Replication

Option | Value
--- | ---
Is Published |
Is Subscribed |
Is Distributor |
Sync With Backup |

## Database Snapshots

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

## Service Broker

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

## 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 |  |  |  |
1 | PRIMARY | ROWS FILEGROUP |  |  | MS_Description | Primary filegroup for the AdventureWorks2008 sample database. mobi update
3 | test1fg | ROWS FILEGROUP |  |  | MS_Description | aaaa
4 | test2fg | ROWS FILEGROUP |  |  |  |
5 | test3fg | ROWS FILEGROUP |  |  |  |
6 | test4fg | ROWS FILEGROUP |  |  |  |

## 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