Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Backup
Message
General information
Forum:
Microsoft SQL Server
Category:
Backups
Title:
Re: Backup
Miscellaneous
Thread ID:
00850106
Message ID:
00850230
Views:
13
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
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform