11 Replies Latest reply: Nov 8, 2011 8:08 AM by clint pauyon RSS

Sql server backup

akshit sharma
Currently Being Moderated

Hi experts,

 

I am using Sql server 2005 with win 2k3 64 bit. From last few weeks my daily scheduled full back up is getting failed repeatedly.

 

here is some logs related to the problem.

 

Nov  2 2011  2:00AM Backup Tape 'RD02S' (family ID 1, sequence 1, media_set_guid {17DC9977-486D-44F6-AEE3-B50B491DD86B}) is mounted on tape drive 'R3DUMP0(
.\Tape2147483645)'. This is an informational message only. No user act

Nov  2 2011  2:40AM Backup Tape 'RD02S' was dismounted from drive 'R3DUMP0(
.\Tape2147483645)'. This is an informational message. No user action is required.

Nov  2 2011  2:42AM spid126 Error: 18210, Severity: 16, State: 1.

Nov  2 2011  2:42AM spid126 BackupTapeFile::UnloadTape: PrepareTape(UNLOCK) failure on backup device '
.\Tape2147483645'. Operating system error 21(The device is not ready.).

Nov  2 2011  2:42AM Backup Error: 3041, Severity: 16, State: 1.

Nov  2 2011  2:42AM Backup BACKUP failed to complete the command BACKUP DATABASE PRD. Check the backup application log for detailed messages.

 

Kindly help me out of this.

 

 

Regards

 

Akshit Sharma

Actions