Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement