Skip to Content
Former Member
Jul 18, 2011 at 11:24 AM

Error while doing DBRestore of MSSQLServer 2005 DB on WindowsServer2008R2


Hi ,

We are facing an issue while doing DB Restore .

Our present SAP Environment is

OS-Windows 2003

DB-MSSQL Server 2005 SP3

SAP -XI3.0 SP19

and we are trying to do a copy of our development server to new environment

OS- Windows 2008 R2

DB-MSSQL Server 2005 SP3

SAP -XI3.0 SP19

We have done CI and DB installation(standard installation).

Now trying to do DB Restore .For that , we took Full DB backup file *.bak of current development system .Selected "Overwrite the existing Database" and "Leave the database ready to use by rolling back uncommitted transactions.Additional transactional logs cannot be restored (RESTORE WITH RECOVERY)" options in SQL Server Studio DB restore option and now facing the error

" Restore failed for Server '<Our server>(Microsoft.sqlserver.smo)

Additional Information System.Data.Sqlclient.sqlerror:Restore detected an error on page (0:0) in database <Database> as read from the backup set .(Microsoft .SqlServer.SMO).'"

Any idea why this error is occurring ?Please help .