November 29, 2001 at 5:01 am
Hi all,
I hope someone can help. I have a Sql Server 6.5 Database that i need to shrink. It currently has a total size of 2200 MB 2000MB data and 200MB Logs. it is reporting 1432MB avalible for data. however when i try to shrink this it is reporting a minimum size possible of 2150MB. Having never used 6.5 much i do not know if there is any way to fix this
Matt Thompson.
November 29, 2001 at 5:33 am
Don't know sql 6.5 too well, but I solved a similar issue in SQL 7/2000 by shrinking the individual file. From BOL:
"The target size for data and log files as calculated by DBCC SHRINKDATABASE can never be smaller than the minimum size of a file. The minimum size of a file is the size specified when the file was originally created, or the last explicit size set with a file size changing operation such as ALTER DATABASE with the MODIFY FILE option or DBCC SHRINKFILE. For example, if all the data and log files of mydb were specified to be 10 MB at the time CREATE DATABASE was executed, the minimum size of each file is 10 MB. DBCC SHRINKDATABASE cannot shrink any of the files smaller than 10 MB. If one of the files is explicitly grown to a size of 20 MB by using ALTER DATABASE with the MODIFY FILE option, the new minimum size of the file is 20 MB. To shrink a file to a size smaller than its minimum size, use DBCC SHRINKFILE and specify the new size. Executing DBCC SHRINKFILE changes the minimum file size to the new size specified."
Hope this also applies in sql 6.5.
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
November 29, 2001 at 10:09 am
AFAIR, you cannot shrink in v6.5. This was a problem for us in the past. I know at one point, we archvived a bunch of data, then bcp'd out all data, rebuilt the db and bcp'd all data back in.
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply