If you're unhappy with SQL Server's native backup facility, take a look at SQL Lite Speed:
http://www.dbassociatesit.com/-Mike
>Hi All:
> I am using the following commands to backup a entire database. Is this the most efficient way to backup a database or should I be using some other device to backup my database?
>
>-- Back up the full Datawarehouse database.
>--This is scheduled to run once a week.
>BACKUP DATABASE Datawarehouse
> TO FullPhxDataBackup
> WITH INIT
>
>-- Back up the log of the Datawarehouse database.
>--This too is scheduled to run once a week.
>BACKUP LOG Datawarehouse
> TO FullPhxLogBackup
>
>-- Create a differential database backup, appending the backup
>-- to the backup device containing the database backup.
>--This is scheduled to run everyday.
>BACKUP DATABASE Datawarehouse
> TO DiffPhxDataBackup
> WITH DIFFERENTIAL
>
>Thanks
>MA