SQL Server - DBCC - WHat does this result mean.

Asked By Dan-902

13-Nov-09 11:16 AM

1> DBCC SHRINKDATABASE (QBM, 10)
2> go
DbId   FileId      CurrentSize MinimumSize UsedPages   EstimatedPages
------ ----------- ----------- ----------- ----------- --------------
5           1       20920         128       17376          17376
5           2         160         128         160            128

(2 rows affected)
DBCC execution completed. If DBCC printed error messages, contact your
system
administrator.

14-Nov-09 06:21 AM

hi,

result is documented at
http://msdn.microsoft.com/en-us/library/ms190488.aspx
regards
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
http://www.hotelsole.com - http://www.hotelsolericcione.de
--------- remove DMO to reply

14-Nov-09 08:17 PM

Cool thanks Andrea - does all MSDE database automatically have a data and
log file?

Dan

15-Nov-09 08:28 AM

hi Dan,

yes, the architecture is mandatory.. at least a single data file and a
single transaction log file..
additional data or log file can be added..
regards
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
http://www.hotelsole.com - http://www.hotelsolericcione.de
--------- remove DMO to reply