SQL Server Performance Forum – Threads Archive

shrink database question

i’m shrinking 2 databases at the same time to their minimum value. i used enterprise manager to schedule the job. there won’t be nobody using the server tonight, but i wonder if they’re going to be able to access the data tomorrow morning, assuming this shrinking process hasn’t finished yet.

If process hasn`t finished, your users will have problems to use database. Shrink process use high I/O.
Even if shrink finish well, all your previus maintenance jobs (reindex, etc) will lost. So, may be, you will loose performance. Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

wow…, any way to tell the percentage of the shrink job been processed already???
Thanks

The SHRINK process doesn’t put any locks or issues to access the data, and if it cannot proceed it will leave the warning message on the SQL SErver error log. By using SP_SPACEUSED you can find how much space is used so far. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>