Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Backup
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Backups
Title:
Backup
Miscellaneous
Thread ID:
00850106
Message ID:
00850106
Views:
49
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
Map
View

Click here to load this message in the networking platform