General information
Forum:
Microsoft SQL Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only