Error while doing DBRestore of MSSQLServer 2005 DB on WindowsServer2008R2

[Former Member]

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 .

Thanks,

Padmaja

[Former Member]

Dear,

The transaction Log backup should be Restore with SQL Enterprise Studio.

Then you have to select the Restore & Transaction Log from the disk.

It will be working fine.

Regards

Thomas.T

[Former Member]

Hi Padmaja!

Possibly this backup file is corrupted; try verifying it by triggering a command like (check before in Books Online😞

restore verifyonly from disk='<path><backupfile>.bak'

Cheers!

--Jesú