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 |
|
scottpt
Posting Yak Master
186 Posts |
 Posted - 2005-12-05 : 09:31:44
|
| I cannot get a datafile to shrink. Ran DBCC DBREINDEX on all tables. DBCC Updateusage. There are image columns. Any help would be appreciated. |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2005-12-05 : 12:10:00
|
| Also tried udating all stats. Moved all tables with a image or text colum to a different db, truncated, shrunkdb, then moved them back. Still could not shrink db |
 |
|
|
bakerjon
Posting Yak Master
145 Posts |
Posted - 2005-12-05 : 15:18:31
|
| Are you using DBCC Shrinkfile or DBCC shrinkdatabase? ShrinkDB has some known issues around trying to shrink files you really don't care about. SHRINKFILE on the other hand lets you target the specific file you are trying to make smaller, and it even lets you do an EMPTYFILE so you can remove a file that you no longer need.HTHJon-Like a kidney stone, this too shall pass.http://www.sqljunkies.com/weblog/outerjoin |
|
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-12-06 : 00:19:30
|
| Hi,USE yourdbGODBCC SHRINKFILE (yrdbdatafile, MB)GOafter doing this is it shrink or not ?:-)RegardsAndy DavisActivecrypt Team--------------------------------------------SQL Server Encryption Softwarehttp://www.activecrypt.com |
|
|
|
|
|
|
Shrinkfile 7.0 not working