THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Roman Rehak

Issue with restoring 2000 backups on 2008

Recently we've been experiencing a lot of headaches with SQL Server 2008 crashing while restoring a backup taken on a SQL Server 2000 production server. The crash resulted in a stack dump but SQL Server would continue running, although less stable, and sooner or later needed a reboot.

The error was saw was this:

Error: 3414, Severity: 21, State: 1.

An error occurred during recovery, preventing the database 'XYZ' (database ID 10) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.

In addition, the event log in SQL Server has many info messages about the stack dump. I've been working with SQL Server support on this and as it turns out, there is an issue in the code that reads a 2000 backup and restores it on 2008. It works OK going from 2000 to 2005. The issue has been fixed in the Cummulative update 3 for SQL Server 2008 -

If you run into this issue, you can request the hot fix from the above URL.

Published Monday, November 2, 2009 3:22 PM by roman


No Comments
New Comments to this post are disabled
Privacy Statement