[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2014-08-19
6
Medium Priority
?
1,699 Views
Last Modified: 2014-08-21
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
0
Comment
Question by:243johnm
  • 3
  • 3
6 Comments
 
LVL 4

Expert Comment

by:dswatt
ID: 40270097
Curious question, Are you restoring from SQL Express to SQL Express or trying to go from SQL Express to SQL Standard?
0
 
LVL 1

Author Comment

by:243johnm
ID: 40270129
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
 
LVL 4

Accepted Solution

by:
dswatt earned 2000 total points
ID: 40270186
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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 1

Author Comment

by:243johnm
ID: 40270370
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
 
LVL 4

Expert Comment

by:dswatt
ID: 40270392
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
 
LVL 1

Author Comment

by:243johnm
ID: 40275772
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

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question