Maintenance and Monitoring - Microsoft SQL Server 2008 R2 Administration - page 337

GO

--BACKUP to a TAPE device
BACKUP DATABASE AdventureWorks2008R2

TO TAPE='\\.\tape0';

GO

--BACKUP to a logical device
--A logical device can be disk dump device/network disk backup/
tape backup device
--Use SP_ADDUMPDEVICE to define a logical device
--Here we will create the logical device and perform BACKUP
database
USE master
GO
EXEC sp_addumpdevice 'disk', 'AWorks2008R2DB',
'G:\Backups\DB_Backups\AdventureWorks2008R2-Data.bak';
GO
BACKUP DATABASE AdventureWorks2008R2
TO AWorks2008R2DB
WITH FORMAT;
GO

We are now ready to ensure the disaster readiness activities.

5. Test the entire backup and restore recovery procedures thoroughly.

For additional checking on data and backups to increase
the probability of error detection, use the RESTORE
VERIFYONLY statement on the backup set.

6. Ensure that you define and document all the required steps to recover from
various failures.
7. Ensure that you check the schedule of backup and restore jobs that include both
system and user databases.
8. Always maintain the system logs intact. Archive windows operating systems event
viewer logs for system, application, and security.
9. Keep a record of all required network libraries and the security mode used for all SQL
Server instances.
10. Maintain a base-functionality script for a quicker assessment. Audit all
important actions.