Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Since using the new version of Symantec, I've experienced lots of problems doing incremental backups of clients' SQL databases.

Is Windows Server backup a good alternative to Symantec Backup Exec 2012 for backing up SQL databases?

share|improve this question
3  
Which "SQL database" are you using? Oracle? PostgreSQL? –  a_horse_with_no_name Sep 21 '12 at 8:21
    
"SQL" = Structured Query Language - a language standard, but not a product... we'll need to know what actual product you're talking about... –  marc_s Sep 21 '12 at 11:37
    
It would probably be more valuable for you if you described precisely the problems you're encountering doing these backups so that you can get help fixing them. Changing backup mode of operation is potentially costly (in terms of all the things you need to test). –  Mat Sep 21 '12 at 11:47
add comment

1 Answer

up vote 1 down vote accepted

In my opinion, the best product for performing SQL backups is SQL Server itself. When space permits, I backup to local disk (full + differential, tx log backups every 10 minutes). These files can then be backed up by your third party software (to tape, NAS, etc.).

If I need to do an emergency restore (assuming a non-drive related issue), I already have the files local to the server, no need to mess around with restoring from tape or copying across a network.

One client of mine had used a third party software to backup files directly to tape (a proprietary format). Two years later they needed to do a restore (audit). They had a great deal of difficulty performing the restore because in the meantime they had upgraded the OS and the backup software, which no longer was compatible with the tapes they had from before.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.