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. _________