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 |
|
rsum
Starting Member
2 Posts |
 Posted - 2008-01-06 : 23:59:40
|
I would like to implement the following backup strategy in SQL Server 2000: - full backup is done once a week
- diff backup daily
- tran backup every hour
How should I approach this. Should I use a backup device linked to a hard disk file? Should I create a backup device for each type of backup (full, diff, tran) and schedule it. If I use a backup device how do I distinguish each backup for old backups.thanks |
|
|
priyakara
Starting Member
3 Posts |
Posted - 2008-01-07 : 20:14:21
|
| Create a DTS Pkg to get the backups It'll distinguish each backup by date and time-----------------E! |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-07 : 22:27:19
|
| priyakara, you may mean use maintenance plan instead of dts. rsum, better to backup to file directly. Easy to distinguish each backup that way. |
|
|
|
rsum
Starting Member
2 Posts |
Posted - 2008-01-08 : 02:57:49
|
| Thanks. Since you can not do a diff backup with maintenance plans, is this a good way to go. Especially if I do a tran backup every 1 hour. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-08 : 22:21:57
|
| You can still use maintenance plan to do other things, just need your own code for diff backup. |
|
|
|
|
|
|
Backup Plan