Sql server backup

akshit sharma Nov 2, 2011 11:17 AM

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

Re: Sql server backup

Deepak Kori Nov 2, 2011 11:35 AM (in response to akshit sharma)

Currently Being Moderated

Hi,

Can you check whether tape lock have been remove from the tape. Probably tape is in read only mode.

Regards,
Deepak Kori
Report Abuse

Like (0)
Re: Sql server backup

Steve SOUMAH Nov 2, 2011 11:36 AM (in response to akshit sharma)

Currently Being Moderated

Hi,

Seems like ther is a problem with the tape drive or the tape itself.
You should check the tape drive and/or have a look a the tape as it seems that the requested tape for the backup isn't in.
BR,
Steve.
Report Abuse

Like (0)
Re: Sql server backup

clint pauyon Nov 2, 2011 3:52 PM (in response to akshit sharma)

Currently Being Moderated

Hi,

Please use a cleaning cartridge. Then restart the tape drive (on and off for 2 minutes) then restart
windows. Try inserting other tapes. Lets try to isolate the problem if it fall to hardware failure.

Thanks.

Clint
Report Abuse

Like (0)
- Re: Sql server backup
  
  akshit sharma Nov 3, 2011 8:30 AM (in response to clint pauyon)
  
  Currently Being Moderated
  
  HI,
  
  thanks for the reply,
  
  Actually we are using 30 different tapes for the scheduled backup. so, i think tape lock is not a issue.
  
  also, we have recently changed the tape drive.
  
  I also have tried to take a log backup manually on the same tape drive and it was successful.
  
  do i have to initialize the new tape drive in SAP or any other configurations changes in scheduled backup i need to make???
  
  regards
  
  Akshit sharma
  
  Report Abuse
  
  Like (0)
  - Re: Sql server backup
    
    clint pauyon Nov 3, 2011 8:43 AM (in response to akshit sharma)
    
    Currently Being Moderated
    
    Hi,
    
    Upon changing the new tape drive did it back-up successfully for the first time usage?
    have tried using tape cartridge cleaner?
    Did you restarted the Operating System together with the tape drive?
    
    Regards,
    
    Clint
    
    Report Abuse
    
    Like (0)
    - Re: Sql server backup
      
      akshit sharma Nov 3, 2011 9:36 AM (in response to clint pauyon)
      
      Currently Being Moderated
      
      Hi Clint,
      
      thanks for the quick reply.
      
      After changing the tape drive the manual log backup is become successful but scheduled Full backup is failed again .
      
      yes, i cleaned the tape cartridge.
      
      Regards
      
      Mohit Joshi
      
      Report Abuse
      
      Like (0)
      - Re: Sql server backup
        
        clint pauyon Nov 3, 2011 9:53 PM (in response to akshit sharma)
        
        Currently Being Moderated
        
        Hi,
        
        What is your scheduled backup? By script to sql built scheduler.
        Try manual backup if still successful and check harddrive space.
        
        You can try getting the database and restore in a test sql then do a manual or schedule
        backup if error occurs.
        
        Thanks.
        
        Clint
        
        Report Abuse
        
        Like (0)
        
        Re: Sql server backup
        
        akshit sharma Nov 5, 2011 8:10 PM (in response to clint pauyon)
        
        Currently Being Moderated
        
        HI,
        
        thanks for the reply.
        
        clint-
        
        i found that my SQLAgent service is stopped, i started it again. till yesterday i was able to take a backup through ntbackup and Sqlserver, but on SAP again it is showing error.
        
        now, i am getting a different error , this is the error which i am facing now.
        
        System.Data.SqlClient.SqlError: Cannot open backup device 'R3DUMP0(
        .\tape0)'. Operating system error 2
        
        check if you have any solution to this.
        
        regards
        
        Akshit sharma
        
        Report Abuse
        
        Like (0)
        
        Re: Sql server backup
        
        clint pauyon Nov 8, 2011 8:08 AM (in response to akshit sharma)
        
        Currently Being Moderated
        
        Hi,
        
        By the way what is your scheduled backup through SQL Server or SAP backup Scheduler?
        
        thanks.
        
        Clint
        
        Report Abuse
        
        Like (0)
        
        Re: Sql server backup
        
        akshit sharma Feb 27, 2012 12:44 PM (in response to clint pauyon)
        
        Currently Being Moderated
        
        Hi,
        
        Problem is resolved. the problem is related to Tape Drive.
        
        Regards
        Akshit Sharma
        
        Report Abuse
        
        Like (0)
Re: Sql server backup

Marius Burger Nov 3, 2011 2:23 PM (in response to akshit sharma)

Currently Being Moderated

good day,

please see if this might help you

http://support.microsoft.com/kb/940379

kind regards
marius
Report Abuse

Like (0)
Re: Sql server backup

ganesh borase Nov 8, 2011 8:03 AM (in response to akshit sharma)

Currently Being Moderated

Hi!
try for
scheduling job from DB13 and select the option initialize, and format media
Also check any other job is start/running on same time which write backup
on the tape media.

thanks
Report Abuse

Like (0)

Go to original post