Restore fails with error - RESTORE detected an error on page (29285:1953383791) in database "MBACRMSQL2008R2" as read from the backup set.

I received an error message with a restore using SSMS for SQL Server 2008R2 (Express Edition):

System.Data.SqlClient.SqlError: RESTORE detected an error on page (29285:1953383791) in database "MBACRM-SQL-2008R2" as read from the backup set. (Microsoft.SqlServer.Smo)

So I then did a restore using a SQL Script. See http://www.experts-exchange.com/Database/MS-SQL-Server/Q_28500553.html for details.

I used the script:
RESTORE DataBase MBACRMSQL2008R2
from disk = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MAXIMIZER\MSSQL\Backup\MBACRM-SQL2000.bak'
with REPLACE,
MOVE 'MBACRM' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MAXIMIZER\MSSQL\DATA\MBACRMSQL2008R2.mdf',
MOVE 'MBACRM_log' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MAXIMIZER\MSSQL\DATA\MBACRMSQL2008R2_log.ldf' 
GO

Open in new window


It failed with essentially the same error message:

Msg 3183, Level 16, State 2, Line 1
RESTORE detected an error on page (29285:1953383791) in database "MBACRMSQL2008R2" as read from the backup set.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Any ideas on how to complete this? Before doing the backup, I ran DBCC CHECKDB on the SQL Server 2000 DB and there were no errors...

Thanks very much,

John
LVL 1
243johnmAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dswattCommented:
Curious question, Are you restoring from SQL Express to SQL Express or trying to go from SQL Express to SQL Standard?
0
243johnmAuthor Commented:
SQL Server 2000 to SQL Server 2008R2 Express. We're actually upgrading to SQL Server 2012 Enterprise Edition. As I have 2008R2 Express on my laptop, I'm using it as an intermediate step.

John
0
dswattCommented:
I try not to use Express, I have done upgrades on 2000 to 2005, same db from 2005 - 2008, and then again to 2012 getting ready to think about 2014.
I run a hyper V install on my laptop with server 2012 and SQL 2012, and use that as a starting point for my upgrade path, keeping my versions in synch, maybe worth considering, can be setup really low spec, dynamic memory and all that good stuff.

I found this link in my prep for 2014 upgrade, maybe worth a look for you, as you defo need an intermediate step, something is nagging me about 2008 express that I cant quite get my head around, if it comes back later I'll post.

http://blogs.technet.com/b/mdegre/archive/2009/07/21/migration-sql-server-2000-to-sql-server-2008.aspx 
the additional links populate over to 2014 but once your db is running under 2008 you should have no worries going to 2012 or 2014.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

243johnmAuthor Commented:
I'm a VMWare guy myself, have been since about 2005 or so. I have 2 laptops, one is my app laptop and the other my demo, data conversion & training laptop. I have all kinds of different VM's on an HDD that I always carry with me, including VM's with full SQL 2005 & 2008R2. However, my demo laptop is back in my hotel room: the fan doesn't start! I have ordered a fan, but it won't be delivered until later this week...

I have an app that uses SQL Server 2008R2 on my app laptop so that's why I'm using it. However, unlike my other laptop, the HDD is too small for me to run VM's.

As we're upgrading to SQL Server 2012 Enterprise Edition, my client is in the process of mounting a VM with SQL Server 2008R2 Enterprise Edition on it (based on http://msdn.microsoft.com/en-us/library/ms143393%28v=sql.105%29.aspx). That should do the trick!

Thanks very much,

John
0
dswattCommented:
I was a VMware guy as well from WS 2.0, but made the switch and my performance during demo's  using 3 VM's running Win 2012 improved dramatically.
still miss VMware, wish they would run together but no such luck :)
0
243johnmAuthor Commented:
Just to confirm, my client setup a temporary VM with SQL Server 2008R2 Enterprise Edition on it. The conversion from SQL 2000 was successful, as was the subsequent conversion to SQL Server 2012 Enterprise Edition.

Thanks again dswatt, left Ottawa (to go back home to Montreal) on time yesterday at noon!

John
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.