name db_size owner dbid created status compatibility_level -------------------------------------------------------------------------------------------------------------------------------- ------------- -------------------------------------------------------------------------------------------------------------------------------- ------ ----------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------- AdventureWorks2012 237.75 MB sa 10 Oct 9 2012 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=706, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAnsiNullsEnabled, IsAnsiPaddingEnabled, IsAnsiWarningsEnabled, IsArithmeticAbortEnabled, IsAutoCreateSt 110 name fileid filename filegroup size maxsize growth usage -------------------------------------------------------------------------------------------------------------------------------- ------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------ ------------------ --------- AdventureWorks2012_Data 1 C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_Data.mdf PRIMARY 242688 KB Unlimited 16384 KB data only AdventureWorks2012_Log 2 C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\[AdventureWorks2012_log.ldf NULL 768 KB Unlimited 10% log only name db_size owner dbid created status compatibility_level -------------------------------------------------------------------------------------------------------------------------------- ------------- -------------------------------------------------------------------------------------------------------------------------------- ------ ----------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------- AUTOS 20.00 MB sa 12 Dec 21 2012 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, Version=706, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled 110 name fileid filename filegroup size maxsize growth usage -------------------------------------------------------------------------------------------------------------------------------- ------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------ ------------------ --------- AUTOS_DAT 1 C:\MSSQL\DATA\AUTOS-DAT.MDF PRIMARY 16384 KB Unlimited 4096 KB data only AUTOS_LOG 2 C:\MSSQL\LOG\AUTOS-LOG.LDF NULL 4096 KB 2147483648 KB 1024 KB log only name db_size owner dbid created status compatibility_level -------------------------------------------------------------------------------------------------------------------------------- ------------- -------------------------------------------------------------------------------------------------------------------------------- ------ ----------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------- BASIC 6.00 MB sa 11 Dec 4 2012 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, Version=706, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled 110 name fileid filename filegroup size maxsize growth usage -------------------------------------------------------------------------------------------------------------------------------- ------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------ ------------------ --------- BASIC_DAT 1 C:\MSSQL\DATA\BASIC.MDF PRIMARY 5120 KB 20480 KB 20% data only BASIC_LOG 2 C:\MSSQL\LOG\BASIC.LDF NULL 1024 KB 5120 KB 512 KB log only name db_size owner dbid created status compatibility_level -------------------------------------------------------------------------------------------------------------------------------- ------------- -------------------------------------------------------------------------------------------------------------------------------- ------ ----------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------- MATH 328.00 MB sa 7 Nov 23 2012 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, Version=706, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled 110 name fileid filename filegroup size maxsize growth usage -------------------------------------------------------------------------------------------------------------------------------- ------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------ ------------------ --------- MATH_PRI_DAT 1 C:\MSSQL\DATA\MATH.MDF PRIMARY 65536 KB Unlimited 65536 KB data only MATH_ALL_LOG 2 C:\MSSQL\LOG\MATH.LDF NULL 73728 KB 2147483648 KB 32768 KB log only FN_MATH_P1 3 C:\mssql\data\FN_MATH_P1.NDF FG_MATH_P1 65536 KB Unlimited 65536 KB data only FN_MATH_P2 4 C:\mssql\data\FN_MATH_P2.NDF FG_MATH_P2 65536 KB Unlimited 65536 KB data only FN_MATH_P3 5 C:\MSSQL\DATA\FN_MATH_P3.NDF FG_MATH_P3 65536 KB Unlimited 65536 KB data only name db_size owner dbid created status compatibility_level -------------------------------------------------------------------------------------------------------------------------------- ------------- -------------------------------------------------------------------------------------------------------------------------------- ------ ----------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------- PUBS_DW 4808.00 MB sa 14 Jan 10 2013 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=706, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled 110 name fileid filename filegroup size maxsize growth usage -------------------------------------------------------------------------------------------------------------------------------- ------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------ ------------------ --------- PUBS_DW_DAT 1 C:\MSSQL\DATA\PUBS_DW.MDF PRIMARY 983040 KB Unlimited 65536 KB data only PUBS_DW_LOG 2 C:\MSSQL\LOG\PUBS_DW.LDF NULL 2916352 KB 2147483648 KB 8192 KB log only FN2011001V 3 C:\MSSQL\DATA\FN2011001V.NDF FG2011001V 128000 KB Unlimited 25600 KB data only FN2011002V 4 C:\MSSQL\DATA\FN2011002V.NDF FG2011002V 128000 KB Unlimited 25600 KB data only FN2011003V 5 C:\MSSQL\DATA\FN2011003V.NDF FG2011003V 128000 KB Unlimited 25600 KB data only FN2011004V 6 C:\MSSQL\DATA\FN2011004V.NDF FG2011004V 128000 KB Unlimited 25600 KB data only FN2012001V 7 C:\MSSQL\DATA\FN2012001V.NDF FG2012001V 128000 KB Unlimited 25600 KB data only FN2012002V 8 C:\MSSQL\DATA\FN2012002V.NDF FG2012002V 128000 KB Unlimited 25600 KB data only FN2012003V 9 C:\MSSQL\DATA\FN2012003V.NDF FG2012003V 128000 KB Unlimited 25600 KB data only FN2012004V 10 C:\MSSQL\DATA\FN2012004V.NDF FG2012004V 128000 KB Unlimited 25600 KB data only name db_size owner dbid created status compatibility_level -------------------------------------------------------------------------------------------------------------------------------- ------------- -------------------------------------------------------------------------------------------------------------------------------- ------ ----------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------- ReportServer 15.19 MB sa 5 Sep 25 2012 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, Version=706, Collation=Latin1_General_CI_AS_KS_WS, SQLSortOrder=0, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled 110 name fileid filename filegroup size maxsize growth usage -------------------------------------------------------------------------------------------------------------------------------- ------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------ ------------------ --------- ReportServer 1 C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ReportServer.mdf PRIMARY 5184 KB Unlimited 1024 KB data only ReportServer_log 2 C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ReportServer_log.ldf NULL 10368 KB 2147483648 KB 10% log only name db_size owner dbid created status compatibility_level -------------------------------------------------------------------------------------------------------------------------------- ------------- -------------------------------------------------------------------------------------------------------------------------------- ------ ----------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------- ReportServerTempDB 5.13 MB sa 6 Sep 25 2012 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=706, Collation=Latin1_General_CI_AS_KS_WS, SQLSortOrder=0, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled 110 name fileid filename filegroup size maxsize growth usage -------------------------------------------------------------------------------------------------------------------------------- ------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------ ------------------ --------- ReportServerTempDB 1 C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ReportServerTempDB.mdf PRIMARY 4160 KB Unlimited 1024 KB data only ReportServerTempDB_log 2 C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ReportServerTempDB_log.ldf NULL 1088 KB 2147483648 KB 10% log only name db_size owner dbid created status compatibility_level -------------------------------------------------------------------------------------------------------------------------------- ------------- -------------------------------------------------------------------------------------------------------------------------------- ------ ----------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------- WILDLIFE 4.63 MB sa 8 Dec 4 2012 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, Version=706, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled 110 name fileid filename filegroup size maxsize growth usage -------------------------------------------------------------------------------------------------------------------------------- ------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------ ------------------ --------- WILDLIFE 1 C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\WILDLIFE.mdf PRIMARY 3136 KB Unlimited 1024 KB data only WILDLIFE_log 2 C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\WILDLIFE_log.ldf NULL 1600 KB 2147483648 KB 10% log only