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 |
|
thecoffeeguy
Yak Posting Veteran
98 Posts |
 Posted - 2006-12-11 : 19:10:34
|
| Just as the subject states.Does anyone use this for DB backups? Either DB or TLogs?I've been reading over this, looking at options. There is one option I was curious about and was hoping someone could fill me in on what i means.It is a option to put a check box in:"Remove unused space from database files."What exactly does that mean?What should maintenanceplans be used primarily for?Should backups be done through this option, or from something else?Thanks, |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-11 : 19:50:23
|
| Maintenance plans should not be used. It's easy enough to roll your own. Check out mine:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspxThe remove option just runs DBCC SHRINKDB. Do not run this unless you are absolutely sure you don't need the extra space again or at least in the near future. The database files needed to expand at some point for some reason, so as long as you don't need the extra disk space reclaimed, don't do this. The reason is because you receive a huge performance hit when the file needs to grow again. We use maintenance plans for log shipping only.Tara Kizer |
 |
|
|
Kristen
Test
22859 Posts |
|
|
thecoffeeguy
Yak Posting Veteran
98 Posts |
Posted - 2006-12-12 : 16:48:29
|
| Thank you very much. I appreciate the feedback.Looks like it is good thing to use, just not for backing up. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-12 : 16:54:45
|
| I disagree that it's a good thing to use.Tara Kizer |
|
|
|
thecoffeeguy
Yak Posting Veteran
98 Posts |
Posted - 2006-12-12 : 16:56:31
|
quote:
Originally posted by tkizer
I disagree that it's a good thing to use.Tara Kizer
all around, including backups?  |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-12 : 18:24:28
|
| Yep.Tara Kizer |
|
|
|
|
|
|
DB maintenance plan...good thing to use?