PRODUCTION BACKUP taking in to tape drive directly

[Former Member]

Hi Friends,

We are using SAP ECC EHP3 with Mssql 2005 enterprise edition with windows 2008r2 OS.

Still now we are taking backup to backup drive and after that  we are copying in to tape drive.But now a days we are facing problem with backup drive space issue,for that we are planing to take backup in to tape drive directly.

I want to know below points.

1)Is it possible to take backup in to tape drive directly?

2)If it is possible how to set up the tape for backup ?

3)We can reuse that backup for restore or not?

4)How to configure tape drive as a backup drive in mssql 2005 (SQL Management studio) and Mssql 2008r2.

Please clarify my doubts , if possible provide me some documents.

Thanks in Advance.

[former_member182657]

Hi Rao,

1)Is it possible to take backup in to tape drive directly?

Yes we can take backup on tapes via tape drive directly.For more please follow SAP Note  44449 - Backup strategies with the SQL server

37152 - SQL Server Backup to a dump file

In addition follow SCN thread

Regards,

Gaurav

[former_member188883]

Hi Easwer,

You need to configure tape device on windows server and then follow the guidelines described in thread below http://scn.sap.com/message/4679110#4679110

Additional information in SAP note

Note 44449 - Backup strategies with the SQL server

Hope this helps.

Regards,

Deepak Kori