Viewing 3 posts - 1 through 3 (of 3 total)
SQLRNNR (8/11/2014)
Are you getting any errors?Have you checked for any blocking?
Or is it just that the shrink is running a really long time and never ending?
No, GUI showed the sql...
August 11, 2014 at 10:04 pm
SQLisAwE5OmE (8/11/2014)
If there is cluster index on the purge table, recreate the cluster index and then shrink the database, that should release the space to OS.
Or can we perform...
August 11, 2014 at 9:59 pm
Gazareth (8/11/2014)
Also add print ( @sql ) directly before/after exec ( @sql )...
August 11, 2014 at 9:58 pm
Viewing 3 posts - 1 through 3 (of 3 total)