DBCC - WHat does this result mean.

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.

hi,Dan-902 wrote:result is documented athttp://msdn.microsoft.

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

Cool thanks Andrea - does all MSDE database automatically have a data andlog

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

Dan

hi Dan,Dan-902 wrote:yes, the architecture is mandatory..

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