Backup 2005

[mystaff]

Hi all,

I have an sql 2005 and on the same server i have a Dat72, how can i configure the sql to make backups on the dat?

thanks all

 

[mrdenny]

You'll need to setup the tape backup drive in Windows. Then setup a backup drive to point to that drive.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[mystaff]

mrdenny,,

how can i do that? do you have any doc?


regards

 

[mrdenny]

As for getting the tape drive setup in Windows, you'll need to check the docs which came with the drive, or the drive OEM.

As for adding it as a backup device in SQL, check BOL under sp_addumpdevice.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog