Copy file to tape with mssql 2005

Hi,

I'm currently setting up our backup strategy using an sql job. I am trying to find out if it is possible to copy a backup made using the sql command:

"BACKUP DATABASE SiteDB TO DISK = '\\bakStorage\sql1.bak'

to a tape device on the same server by using an sql command that can be added as a step in the job?

Many Thanks
Lee
ljhodgettAsked:
Who is Participating?
 
Atdhe NuhiuCommented:
Hmm don't think so unless you back your filesystem up to tape
0
 
Atdhe NuhiuCommented:
BACKUP DATABASE SiteDB
   TO TAPE = '\\.\Tape0'
   WITH NOINIT,
      NAME = 'Full Backup of SiteDB ';

0
 
Atdhe NuhiuCommented:
BACKUP DATABASE SiteDB
   TO SiteDB_Tape
   WITH FORMAT,
      MEDIANAME = 'SiteDB_Tape',
      MEDIADESCRIPTION = '\\.\tape0',
      NAME = 'Full Backup of SiteDB ';

0
 
ljhodgettAuthor Commented:
Hi Andy,

I thought this might be the case. I was hoping to avoid perform the backup twice. I take it that you can not perform a backup to file then copy the file that was created to tape.

Many thanks
Lee
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.