243johnm
asked on
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.SqlE
So I then did a restore using a SQL Script. See https://www.experts-exchange.com/questions/28500553/Restore-script-syntax-error-SQL-Server-2008R2.html for details.
I used the script:
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
System.Data.SqlClient.SqlE
So I then did a restore using a SQL Script. See https://www.experts-exchange.com/questions/28500553/Restore-script-syntax-error-SQL-Server-2008R2.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'
GOIt 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
dswatt
Curious question, Are you restoring from SQL Express to SQL Express or trying to go from SQL Express to SQL Standard?
ASKER
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
John
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
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 :)
still miss VMware, wish they would run together but no such luck :)
ASKER
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
Thanks again dswatt, left Ottawa (to go back home to Montreal) on time yesterday at noon!
John