Tape Drive Inactive(greyed) in SQL Server management studio while backup

[Former Member]

Dear All,

I was trying to schedule backup of my Production Server but when i checked in MS SQL Studio, the Tape option is in inactive, how can i active the Tape.

I followed the SAP note - 1115746 ..but problem is still the same.

I want to know one thing in sap note 1115746 it is written that Add in the same branch as the DeviceType entry a new string value (REG_SZ) with the name "Type" and the content "TapePeripheral":Type = TapePeripheral

When i am rebooting the server this entry automatically got deleted(no entry with this name in the registry)

Please help !

Regards,

Rohit

[clas_hortien · Accepted solution]

Hi,

i'm the author of this note.

In the note it is stated that this new key gets deleted through a reboot.

The driver is responsible for setting this correctly. Ask your Tape Vendor for

a different driver.

When you set the registry key, you do not need to reboot to make this work.

You just can start the Dev. Studio and do a backup.

Maybe you can implement a startup routine to set this key, right after reboot.

Best regards

Clas Hortien

[Former Member · Accepted solution]

Dear All,

Error: 18204, Severity: 16, State: 1.

BackupTapeFile::OpenMedia: Backup device '
.\tape0' failed to open. Operating system error 32(The process cannot access the file because it is being used by another process.)

Unnamed tape was dismounted from drive 'R3DUMP0(
.\tape0)'. This is an informational message. No user action is required.

this is something which i can see in ERROR.LOG file

may be this is because we took backup on tape through ntutility from Hard disk at that time we might face this issue ,.....

but Tape option in sql server management studio is still greyed...

Regards,

Rohit

Edited by: Rohit Goswami on Jul 30, 2009 5:33 PM

[Former Member · Accepted solution]

Dear Clas,

Thanks for the information.

Now I can see the tape option in Sql Server management studio ..after changing the registry value according to the sap note 1115746. but after restarting the Server-system(Machine).Tape option is grey again.... it looks to me OS related issue not related to sap or database.

Regards,

Rohit

Edited by: Rohit Goswami on Jul 30, 2009 5:47 PM

Edited by: Rohit Goswami on Jul 30, 2009 7:24 PM

[markus_doehr2]

> I was trying to schedule backup of my Production Server but when i checked in MS SQL Studio, the Tape option is in inactive, how can i active the Tape.

Can you backup to the tape with ntbackup?

Markus

[Former Member]

Hi Markus,

I can take backup on tape through NTback utility

Regards,

Rohit