Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kinnerton
Starting Member
21 Posts |
 Posted - 2010-04-19 : 10:31:14
|
| First of all - great website!I have tried running :Alter database xxxDB set recovery simpleBackup log xxxDBwith truncate_onlyDBCC SHRINKFILE('xxxDB', 100)Alter database xxxDB set recovery fullBut the DB is only shrinking down to the initial DB size (200Gb). I thought SHRINKFILE supposed to go down to the level you ask?The DB has had a large unwanted application table truncated to free up 70% of the DB size - so we are wanting to set up a smaller Dev DB (at 70ish Gb rather than 350Gb!)Can anyone help? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-19 : 11:01:15
|
The database cannot be made smaller than the minimum size of the database.The minimum size is the size specified when the database was originally created, or the last explicit size set by using a file-size-changing operation, such as DBCC SHRINKFILE.See here:http://msdn.microsoft.com/en-us/library/ms189035.aspx
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Kinnerton
Starting Member
21 Posts |
Posted - 2010-04-19 : 11:22:47
|
| Thank Webfred - I thought that only applies to SHRINKDATABASE. I'm trying to run a SHRINKFILE to reduce the 'initial filesize'. |
|
|
|
|
|
|
ShrinkFile - not releasing unused space