Viewing post 1 (of 2 total)
thanks the tempdb info is:
namedb_sizeownerdbidcreatedstatuscompatibility_level
tempdb 775.06 MBsa2Apr 4 2012Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=655, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics100
and
namefileidfilenamefilegroupsizemaxsizegrowthusage
tempdev1D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\tempdb.mdfPRIMARY194816 KBUnlimited10%data only
templog2D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\templog.ldfNULL598848...
April 5, 2012 at 7:33 am
Viewing post 1 (of 2 total)