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 |
|
fruitbat04
Starting Member
6 Posts |
 Posted - 2007-04-20 : 13:53:58
|
| Hi there,I have a large (420GB) database that has never had data archived off before. I taken a backup to a test server and run a script supplied by the product vendor which has removed a large ammount of old data no longer required.I have checked within enterprise manager that this data has now gone, however the actual file itself has not shrunk in size. Is there a further step I need to take to get back the space.Kind Regards |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-20 : 13:59:27
|
| You have to run 'dbcc shrinkdatabase' or 'dbcc shrinkfile'. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-20 : 14:37:08
|
| And don't forget to run DBCC UPDATEUSAGE to correct inaccuracies in sysindexes.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Shrinking database file after removing data