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 |
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
 Posted - 2008-11-07 : 01:32:35
|
| We have a 40gb DB with much of the space used by images on 2 tables. I am trying to make the the DB size more manageable for development, backing up & taking copies off-site. We don't need the images for now. I have copied the images from one table to another DB. And I have set the image col to null & run dbcc cleantable. Is there something else I need to do before shrinking the database? Thanks |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-11-07 : 02:55:31
|
| Its not a good idea to store images in your DB, So many examples online and in this forums |
 |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-11-09 : 15:08:10
|
| I know. Inherited system - no choice at the moment. Does anyone have feedback on freeing up space? |
|
|
|
|
|
|
Reclaiming space used by images