Backup device not getting detected in MS SQL 2005

[Former Member]

Hi team,

I have one problem regarding SQL backup

I am using Windows 2003 Ent 64bit with SQL 2005 64 bit (SP2)

when i am taking backup using ntbackup its working fine but when i take it from SQL ent manager tape device is not getting detected.

some it hapeens when i delete the tape device from a sql query and afterwards add it works for a day or so.

Thanks & Regards

Navin Somal

[Former Member]

you need to define backup device in Enterprise Manager.

Managemnet -> Backup -> New Backup Device.

Regards,

Nikunj Thaker.

[Former Member]

i have already done that

at the time i delete and define backup device it works for a day or two

after wards its doesnt work

[Former Member]

Hi Nvsomal,

Is your TAPE Drive Option is greyed in Sql Server management studio ?

If yes then have you resolved this issue ?

Regards,

Rohit