November 20, 2003 at 11:06 am
Hi,
Is there any article on the physical space needed to shrink a database. We have 30gb database and 33gb hard disk, do we need to have more hard disk space before trying out SHRINKDATABASE?.
Thanks.
November 20, 2003 at 12:25 pm
shouldn't
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 21, 2003 at 6:09 am
If you are running on SQL Server 7.0, sp3 or earlier, your data file may increase after shrinking it, if you have tables containing binary information. This is fixed in SP4. See KB article 308627 for more info.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply