December 6, 2010 at 5:26 am
I brought a copy of our live DB down to our DEV server and have deleted a lot of data. This now leaves the data file with a size of 85 GB and 37 GB is unused space.
I have tried DBCC SHRINKFILE on the mdf file, but i can not shrink a file to a size smaller then the initial size (which is 85 GB).
How can I reduce the initial size?
I tried:
ALTER DATABASE DB_Name MODIFY FILE (Name = N'data_file', SIZE=50000MB)
but that gives me an error: "MODIFY FILE failed. Specified size is less than or equal to current size".
I have tried the GUI: Right click DB - Properties - Files - Reducing the Initial size, but no luck.
What are my options here? I need to use that space on our DEV server so I need to free up that space....
December 6, 2010 at 8:06 am
Create a new db
copy the current one over there, moving all the schema and data.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 6, 2010 at 8:48 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply