November 20, 2003 at 11:04 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.
Edited by - skravella on 11/20/2003 11:09:13 AM
November 20, 2003 at 11:51 am
I saw you have three same posts there.
quote:
Is there any article on the physical space needed to shrink a database
The BookOnLine is a good reference to start.
quote:
We have 30gb database and 33gb hard disk, do we need to have more hard disk space before trying out SHRINKDATABASE?.
You can check the database properties to see how much space is unused. IF the unused space is less than 10~15% of the total you have, you need to have a new drive.
November 20, 2003 at 1:23 pm
The SHRINKDATABASE command will not shrink the database beyond the minimum size of the file. The minimum size of the file is the size when the file was created or the last explicit set size. Therefore, if you created the database file to 25GB the file will not shrink beyond that.
If you need to shrink the database file to a smaller size use SHRINKFILE.
Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance.
Patrick
Quand on parle du loup, on en voit la queue
November 21, 2003 at 1:19 am
Are your indexes badly fragmented? If so, you could try rebuilding them. This should save you some space.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply