How to Backup to Tape

Question

How to Backup to Tape

vkundar

Hall of Fame

Points: 3431
More actions
December 29, 2008 at 3:51 am

#383647

Hello All,
HJow do I take a DB Full backup to Tape from Maintenace plan. I see the Tape option in maintenance plan but it is dissabled. What should I do to configure this backup.
Thanks for helping me out.
Cheers,
Got an idea..share it !!
DBA_Vishal

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

The native SQL backup and the maintenance plans only support backups to local tape drives.

If your server doesn't have a local tape drive, this option will be disabled. If you want to backup to a network tapedrive you have to use third-party software.

[font="Verdana"]Markus Bohse[/font]

vkundar Hall of Fame Points: 3431 More actions · Answer 2

Thanks for the reply.

Planning to use Tivoli backup software. what parameter shall I consider? What is VDI backup in SQL Server?

Cheers,

Got an idea..share it !!

DBA_Vishal

homebrew01 SSC Guru Points: 55548 More actions · Answer 3

Many of us prefer to backup to local disk, then copy the flat file to tape later. Faster & more reliable

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 4

I would recommend that you manage SQL backups with SQL Server. Run the backups to disk as it's faster, more reliable, and if you have an issue, you can recover quicker.

Then let Tivoli backup the files like any other files on the server.

vkundar Hall of Fame Points: 3431 More actions · Answer 5

Thanks Steve, for the suggestion. I created a maint plan that backup daily to SAN and after that another backup to Tapes using Tivoli.

But my Tivoli backup fails with the TCP/IP connection issue would like to know how should I troublesoot it. I have not much information on this.

Error:

01/15/2009 07:44:25 ANS5216E Could not establish a TCP/IP connection with address 'SERNYKACP:1500'. The TCP/IP error is 'Unknown error' (errno = 10060).

01/15/2009 07:44:25 ANS4039E Could not establish a session with a TSM server or client agent. The TSM return code is -50.

01/15/2009 07:44:25 ANS1017E Session rejected: TCP/IP connection failure

Appreciate your help 🙂

Cheers,

Got an idea..share it !!

DBA_Vishal

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 6

It sounds like the client (TSM client) on the server isn't able to communicate with the TSM server. Perhaps a firewall/router issue?