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 |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2005-08-17 : 04:30:34
|
| My master db is 2 gig & my temp db is 5 gig.When I backup the master db, the backup only takes up 17meg. So can I reduce the amount of space that the master db is taking up? |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-17 : 06:17:20
|
| Shrink it? (in Enterprise Manger - All tasks : Shrink)Kristen |
 |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-08-17 : 06:49:46
|
| Howcome AUTOSHRINK is not allowed? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-17 : 06:58:26
|
| Dunno - but in my experience its a bad idea anyway - it is likely to run at a time of peak activity, because that will be when the database becomes large, etc.Shrinking a database is generally a bad idea because the server has to then reallocate space to grow the files again - if you've done a large DELETE or somesuch and want to reclaim that space then fine, but reclaiming space which will be re-allocated within the next 24hours or so is pointless, will fragement the disk, and waste CPU cycles etc.A 2GB master DB that backs up to 17MB isn't in that category though!Kristen |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-08-17 : 07:06:25
|
| Yeah, I'm converting from an old DB into a new normalized one. Lots of INSERT INTO's and BULK INSERTS. There was 98% free. I assumed if autoshrink was unavailble, so was shrink. But that was so very wrong ofcourse. Duh!Thanks for that. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-17 : 07:46:19
|
"I assumed if autoshrink was unavailble, so was shrink"Me too ... but I went and had a look just in case and got lucky!  Kristen |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-08-17 : 08:11:40
|
| You know what ASSUME does...makes an ASS out of U and ME! (and old one..., but no less true) |
|
|
|
|
|
|
master db and temp db size