Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Problem with backup

Unanswered Problem with backup

  • Wednesday, February 22, 2012 8:53 AM
     
     
    Sign In to Vote
    0

    I have maintenance plan for backing up all database, and it function perfect for 4 mounts.

    No suddenly stop, when i execute give error about step 1 ( which is to backup all database) BACK up TYPE = FULL

    My question is: Some of the database are on simple recovery mode (master and msdb also), so i don't know, do i need to set all database to FULL recovery mode if i do backup try maintenance plan for all database.

     

All Replies

  • Wednesday, February 22, 2012 9:03 AM
     
     
    Sign In to Vote
    0

    i Get this error in event viewer

    BackupMedium::ReportIoError: write failure on backup device 'H:\Backup\master_backup_201202221001.bak'. Operating system error 1117(error not found).

    BACKUP failed to complete the command BACKUP DATABASE master. Check the backup application log for detailed messages.

     
  • Wednesday, February 22, 2012 9:15 AM
     
     
    Sign In to Vote
    0

    Error: 3041, Severity: 16, State: 1.
    BACKUP failed to complete the command BACKUP DATABASE master. Check the backup application log for detailed messages.
    Error: 18210, Severity: 16, State: 1.
    BackupDiskFile::RequestDurableMedia:  failure on backup device 'H:\Backup\master_backup_201202221001.bak'. Operating system error 1117(error not found).

    This is error from error log

    Thank's

     
  • Wednesday, February 22, 2012 9:24 AM
     
     
    Sign In to Vote
    0

    Hi,

    Is the H:\Backup location a local disk drive on the SQL server? Can you write to that location with the SQL server service account and the SQL agent service account - logon as those account and try to create a new text file in H:\Backup.

    Sean Massey | Consultant, iUNITE

    Feel free to contact me through My Blog, Twitter or Hire Me.
    Please click the Mark as Answer button if a post solves your problem!

     
  • Wednesday, February 22, 2012 9:26 AM
     
     
    Sign In to Vote
    0

    Hi ,

    You dont need to set those to full recovery mode. There is no constraint like that.

    The error that you are having Operating system error 1117 means "The request could not be performed because of an I/O device error.".

    Are you trying to backup it to the local disk or to any other media? Try to backup it to a local disk. If you are trying to backup to a network location or USB etc you might get this error due to the network inconsistencies.

    HTH

    Regards, Ashwin Menon My Blog - http:\\sqllearnings.wordpress.com

     
  • Wednesday, February 22, 2012 9:31 AM
     
     
    Sign In to Vote
    0

    Hi ,

    You dont need to set those to full recovery mode. There is no constraint like that.

    The error that you are having Operating system error 1117 means "The request could not be performed because of an I/O device error.".

    Are you trying to backup it to the local disk or to any other media? Try to backup it to a local disk. If you are trying to backup to a network location or USB etc you might get this error due to the network inconsistencies.

    HTH

    Regards, Ashwin Menon My Blog - http:\\sqllearnings.wordpress.com

    I backup all databse to local drive.

    I see error on drive like

    An error was detected on device \Device\Harddisk1\D during a paging operation.

    So is it bad disk, so i can tell my boss to bay another one, or is something bad with sql server 2008 ( i doubt)

     
  • Wednesday, February 22, 2012 9:34 AM
     
     
    Sign In to Vote
    1
    Can you write files to H:\Backup outside of SQL? It sounds like a bad disk. To test its not SQL setup a backup to backup to another location and test that it works.

    Sean Massey | Consultant, iUNITE

    Feel free to contact me through My Blog, Twitter or Hire Me.
    Please click the Mark as Answer button if a post solves your problem!

     
  • Wednesday, February 22, 2012 10:25 AM
     
     
    Sign In to Vote
    0
    I set backup to other disk and give same error?
     
  • Wednesday, February 22, 2012 10:49 AM
     
     
    Sign In to Vote
    0
    Can you write files to H:\Backup outside of SQL? It sounds like a bad disk. To test its not SQL setup a backup to backup to another location and test that it works.

    Sean Massey | Consultant, iUNITE

    Feel free to contact me through My Blog, Twitter or Hire Me.
    Please click the Mark as Answer button if a post solves your problem!


    I get backup to other disk, and know i have problem with Remote connection after logon i see only blue screen.
     
  • Wednesday, February 22, 2012 12:46 PM
     
     
    Sign In to Vote
    2

    There seems to be some problem with the disk. Can you check the event logs to confirm this?

    You should gget similar errors in the event logs. Contact your sysadmins and ask them to do a chckdisk.

    Regards, Ashwin Menon My Blog - http:\\sqllearnings.wordpress.com

     
  • Wednesday, February 22, 2012 12:46 PM
     
     
    Sign In to Vote
    0

    I think is disk because i back up to other local disk, so am gone change backup disk

    Thank's

     
  • Wednesday, February 22, 2012 3:32 PM
     
     
    Sign In to Vote
    0

    There seems to be some problem with the disk. Can you check the event logs to confirm this?

    You should gget similar errors in the event logs. Contact your sysadmins and ask them to do a chckdisk.

    Regards, Ashwin Menon My Blog - http:\\sqllearnings.wordpress.com

    I see errors for disk on event logs, now i run some test to see if disk is ok.