question

Bincy avatar image
Bincy 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.
sqlbackup
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
raadee avatar image
raadee answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
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
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.