Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Backup
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Titre:
Re: Backup
Divers
Thread ID:
00850106
Message ID:
00850230
Vues:
14
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform