|
Subject:
|
dbcc shrinkfile SQL 7
|
|
Posted By:
|
dls1
|
Post Date:
|
12/26/2006 3:17:52 AM
|
I ran a dbcc shrinkfile after deleting data in order to take thte db down in size and it has been running for 2 days. Can I canel the command? Will the file be partially shrunk? Last year when we did this I ran a re-index command. Will I have to run a bakup or truncate log command? I have been trying to get the client to upgrade from SQL 7 but they just have not done it yet.
|
|
Reply By:
|
robprell
|
Reply Date:
|
1/2/2007 6:21:11 PM
|
from my experience this generally means the shrink did not work and nothing was done.
|
