asked
DB backup directly into tape drive
How can i take the database back up into tape drive directly without saving in local disk in sql server 2005.
This web site runs off of votes. Can you please indicate all helpful answers below by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate that by clicking on the check mark next to that one answer.
If your tape drive is directly attached to your server, you have the option to backup to tape instead of disk. Right click on a database -> tasks -> backup. In the destination section you have tape in "backup to". T-SQL Looks like this: BACKUP DATABASE AdventureWorks2008R2 TO TAPE = '\\.\Tape0' If you are using a 3rd party backup system like Tivoli Storage Manager, you can configure backups from the administration software that comes with the system to take backups of your databases to the tape drive. So it depends on how your setup looks like.
Backup to tape is a deprecated feature (meaning it will no longer work in future versions), but for now it still works :
http://msdn.microsoft.com/en-GB/library/ms179313.aspx#TapeDevices
16 People are following this question.
