30 pts.
 Backing up SQL Server 2008 databases to a tape drive
I am running Sql Server 2008 and I need to know how to make backups of the database onto a tape drive. How do I do this?

Software/Hardware used:
ASKED: June 24, 2009  10:36 PM
UPDATED: June 25, 2009  1:28 PM

Answer Wiki:
You'll need to install the drive in the server, and configure a backup device pointing to the tape drive. Then use the BACKUP DATABASE command to backup to the backup device.
Last Wiki Answer Submitted:  June 25, 2009  1:37 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _