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 |
|
RoyalSher
Yak Posting Veteran
95 Posts |
 Posted - 2004-01-29 : 07:42:57
|
| HiI am in a kind of situation where I need to recheck backup of few large databases. I was working out the details of the cause of failure of few db backups. As I was doing this I happen to understand that Backup Device is advisable for large databases than the DB Maint. plan - Complete backup with files to be deleted older than 1 day. Can any body tell me if I understand right, as I need to fix few backup failures in my shop having constraint of no additional space in the backup disk(s) (and not intending to add more space). ? Or rather can anybody tell me what is the diff. of taking backup with a backup device (process) and /or with DB Maint. plan. ? I did some kind of research, but cdn't figure the right point.Thanks in AdvanceRoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
|
|
stephe40
Posting Yak Master
218 Posts |
Posted - 2004-01-29 : 10:42:01
|
| I dont think there is a difference. A mantenence plan is just a group of operations (reorginize indexes, backup the database, and backup the transaction log). They are ment to help you keep all that stuff organized in one place. A backup is a backup no matter how you start it, whether its started from a maintenece plan or from a backup command.- Eric |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-29 : 16:21:49
|
| Using a backup device does not have any performance advantages or disadvantages regardless of the size of a database. In SQL 6.5, backup devices were used. They are still available in 7.0 and 2000, but not many people use them. A maintenance plan is just a wizard that helps you set up things. Most DBAs with experience do not use wizards. It's kinda like creating/altering your stored procedures in Enterprise Manager. Yes you can do it, but that doesn't mean it's the best way.Tara |
|
|
|
|
|
|
DB Backup using Backup Device & Maint. Plan