March 26, 2009 at 10:16 am
I am shrinking a database of 1 TB as i recently moved some tables from primary to secondary.
DBCC SHRINKDATABASE(N'Rev_Budget_All' )
Its been over 20hrs still running the job, what to do now?
March 26, 2009 at 10:52 am
its probably got loads of data to move so could easily take that long, probably caused blocks, been blocked as well.
You can kill a shrink job, the work it has already done will remain but it wont return the space it has created at the end of the file to the OS.
After you have killed it, if you really need the space re-run the shrinkfile with truncateonly to quickly return the space to the OS.
your database will be fragmented to bits though.
If you have a large file you must shrink always do it in chunks by specifying a size to shrink to and running the job a number of times.
---------------------------------------------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply