Oct 24, 2009 #1 mystaff Technical User May 27, 2009 35 AR 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
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
Oct 25, 2009 #2 mrdenny Programmer May 27, 2002 11,595 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 Upvote 0 Downvote
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
Oct 26, 2009 Thread starter #3 mystaff Technical User May 27, 2009 35 AR mrdenny,, how can i do that? do you have any doc? regards Upvote 0 Downvote
Oct 27, 2009 #4 mrdenny Programmer May 27, 2002 11,595 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 Upvote 0 Downvote
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