THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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 - http://support.microsoft.com/kb/960484.

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

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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement