Post reply

CHECKSUM backups fail to restore or verify...Non-Checksum works...

  • July 22, 2008 at 1:50 pm

    #194193

    Got a strange issue with a server here.

    I've got one database out of a dozen on a single server that fails a RESTORE VERIFYONLY when I add the CHECKSUM option to the backup command. If I remove the CHECKSUM option I can restore the database fine. If I backup and include the CHECKSUM option, I get a successfull backup, but a failure when verifying the backup or trying to restore it.

    DBCC CHECKDB() of the database in question comes back clean.

    Has anyone seen this before?

    Your friendly High-Tech Janitor... 🙂

  • July 22, 2008 at 3:30 pm

    #846730

    Appears to be related to SP2 build 3042 (the "bad" one). Found that the server was reducing backup buffers due to memory pressure. By dropping the MAXTRANSFERSIZE of the backups to 128k I was able to clear the issue.

    Will be installing CU7 later this week and finding out if that's the source of the problem.

    Edit:

    Added relevant details...

    Your friendly High-Tech Janitor... 🙂

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply