Using dbcc shrinkdatabase … | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Using dbcc shrinkdatabase …

Hi : I executed the sql statement :
dbcc shrinkdatabase ([scopes-server])
It executed successfully .. however I do not find any reduction in the size of the .mdf or .ldf file.
What is the target percentage specified?
And check with SP_SPACEUSED on the database.
#
Make sure all the uncomitted transactions are written to the disk by issuing BACKUP LOG or CHECKPOINT statement from query analyzer. So that SHRINK process will continue. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>