Home Forums SQL Server 2005 Backups Backup Log Incorrect Function Message (nonrecoverable I/O error). RE: Backup Log Incorrect Function Message (nonrecoverable I/O error).

  • January 2, 2013 at 3:46 pm

    #1573104

    DB_Newbie2007 (1/2/2013)

    Full backups are done weekly and log backups daily.

    Daily? So up to 24 hours of data loss is acceptable?

    Log backups are usually a lot more frequent than that, most backup strategies I've seen for up to 24 hours acceptable data loss use full and diff backups and simple recovery.

    p.s. A 1 TB database shouldn't take 2-3 days to restore.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass