Restore SQL 2000 DB into SQL 2008 DB Server

Question

Post reply

Restore SQL 2000 DB into SQL 2008 DB Server

Mathew M.Varghese

SSCommitted

Points: 1929
More actions
September 14, 2010 at 1:03 am

#387779

Hi,
When I restore the SQL 2000 ENT database to SQL 2008 ENT. Database server, I am getting following error message.
Processed 5971240 pages for database 'xxxx', file 'xxxx_Data' on file 1.
Processed 170 pages for database 'xxxx', file 'xxxx_Log' on file 1.
Msg 3167, Level 16, State 4, Line 1
RESTORE could not start database 'xxxx'.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Msg 3414, Level 21, State 1, Line 1
An error occurred during recovery, preventing the database 'xxxx' (database ID 6) 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.

Viewing 15 posts - 1 through 15 (of 18 total)

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

Nakul Vachhrajani SSChampion Points: 10294 More actions · Answer 1

Hello!

The first things I would check for are:

1. During the restore, are the DB files being created on disk? (i.e. monitor the folder where you are restoring and see if SQL is able to create the files there)

2. Is the drive/folder compressed?

Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com

Follow me on
Twitter: @sqltwins

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 2

Just a quick question, have you applied the latest SP/CU?

JL

Mathew M.Varghese SSCommitted Points: 1929 More actions · Answer 3

Dear Nakul,

The file are restored in the folder and it is same size of the DB file and logfile.

The folders are not compressed one.

Mathew

Mathew M.Varghese SSCommitted Points: 1929 More actions · Answer 4

Mathew M.Varghese

SSCommitted

Points: 1929

September 14, 2010 at 1:29 am

#1220485

No..I am not appled the latest service pack.

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 5

Mathew M.Varghese (9/14/2010)
No..I am not appled the latest service pack.

I would personally apply the latest SP as a minumum. Normally when setting up a new server I add the latest SP and CU.

JL

Nakul Vachhrajani SSChampion Points: 10294 More actions · Answer 6

Hello!

Thanks for the quick response.

By any chance are there any READ-ONLY filegroups in the database?

http://support.microsoft.com/kb/934713

Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com

Follow me on
Twitter: @sqltwins

nageshp Right there with Babe Points: 719 More actions · Answer 7

Hi,

Can you please validate the backup set with the below command

RESTORE VERIFYONLY FROM DISK='[Mention the path of backupfile]'

Thanks,

Nagesh

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

Sounds like the backup is corrupt or the original database is corrupt. Is there any way you can get a fresh backup of the 2000 database? If so, run this first.

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

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

Mathew M.Varghese SSCommitted Points: 1929 More actions · Answer 9

Hi

I check teh "RESTORE VERIFYONLY FROM DISK='[Mention the path of backupfile]'" and it is successful. It shows message that back is redy for restore.

I check the Check db command and no error message.

Mathew

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 10

Try taking another backup?

With a SQL 2000 backup, Verifyonly is going to check the headers and just a couple other things. Not a guarantee that the backup will restore.

Also can you run CheckCatalog on the 2000 DB?

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

Mathew M.Varghese SSCommitted Points: 1929 More actions · Answer 11

Thanks ..Now the 2000 Db restored in Sql 2008.

The issue was service pack. After i apply the service pack 1, it restore the db in sql 2008.

it shows the following message

Converting database 'xxxx' from version 539 to the current version 655.

Database 'xxxx' running the upgrade step from version 539 to version 551.

..

...

Database 'xxxx' running the upgrade step from version 654 to version 655.

Thanks for all to support to solve this issue

Mathew

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 12

Glad to hear...

I would follow Gail's advice and run CHECKDB, just to be sure. Plus I alway do this when upgrading a DB.

Enjoy

Ali Tailor Hall of Fame Points: 3769 More actions · Answer 13

Hi

All

Pls let me know, SP1 to be install on SQL 2000 or 2008.

Ali
MCTS SQL Server2k8

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 14

Latest patch level for SQL 2000 is SP4, and lower than SP3 there are some really nasty vulnerabilities

Latest patch level for SQL 2008 is SP1

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