What do you guys perfer for SQL Server backup prog?

[customgt]

Hello, we got 2003 SQL server, wasn't sure what most people use to back it up.

Is thier an integrated backup program built in windows server to do this or do you guys use a 3rd party?

Thank you

 

[Wadoki]

We use the built in SQL Backup in SQL. I have used Backup Exec without issue, but I recently switched to Retrospect because it's just as powerfull and half the cost. Both have good SQL agents.

 

[customgt]

So you use retrospect now and not the built in SQL Backup?

Or retrospect for your file system and the built in SQL Backup for the sql

thanks!

 

[pagy]

IMHO best practice for SQL is to use SQL backup to backup the databases and then another backup program to backup the SQL backup files to tape or other media.

I think I said backup enough in one sentence there :->


Paul
MCSE


"Two things are infinite: the universe and human stupidity; and I'm not sure about the the universe."
Albert Einstein

 

[Wadoki]

Correct, SQL backup for the database and transaction logs, and Retrospect for everything else.

 

[LawnBoy]

I agree with pagy and Wadoki. I've never had SQL (MS, Oracle, My) fail to restore a backup it created, but I have had backup agents fail to restore backups they created.

Agents are just another link in a chain that I want as strong and short as possible.


"We must fall back upon the old axiom that when all other contingencies fail, whatever remains, however improbable, must be the truth." - Sherlock Holmes