SQL Server Backup vs tape backup

[gc6294]

Just was hoping to get everyone's thoughts on the merits of doing SQL server backups thru a maintenance plan to bak files vs. not doing sql backups and relying on a tape backup software with a sql agent. I was always under the impression that you should use a combination of both - if you need to restore, the SQL backup is typically easier and more reliable. Just looking to get others thoughts....

 

[ptheriault]

I've always used both. I backup to disk and then write the .bak file to tape. I do this for two reasons.

1. Since I'm a DBA and I don't manage the tape backup software I don't need to rely on someone else If I need to get last nights backup.

2. I have found that most restores are caused by a user doing some harm to the data. If the most recent .bak is still on the server the restore can be that much quicker.

I also am able to copy the .bak file to other servers if I need to.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[SQLBill]

Ask your tape vendor how long it takes them to support changes to Microsoft SQL Server. Some vendors are not able to upgrade their product immediately. So, if MS sends out a new SP that affects how the BACKUP and RESTORE commands work and you apply it, that could stop the backup software's SQL Agent from working properly. If the vendor isn't able to quickly support updates, you might be without backups for 6 months or longer.

-SQLBill

Posting advice: FAQ481-4875