Question Re: Backup & Restore SQL Server 2005 in Technology Q&A

Backup & Restore SQL Server 2005

Former Member — Sat, 09 Jul 2011 12:55:26 GMT

Dear Experts,

One of our SAP system got crash due to some hardware problem . we have rectified the problem and installed the OS again.

Now could you please tell me how to restore taken SQL to bring the system up to date. Now I have Backup datas in my External HDD. I don't have Tape Drive media for that system.

I would appreciate the procedure and steps to be followed backup restore on the SQL 2005 & windows 2003 server system

Please Let me know.

Thanks in advance

Regards

Thomas.T

Re: Backup & Restore SQL Server 2005

ganesh_borase2 — Sun, 10 Jul 2011 03:36:05 GMT

hi,

you have to install SAP on that machine then

1. Detach the database from newly installed sap.

if you had offline backup

2. copy the database from the external HDD to newly installed location for e.g if on installation you had

database location on E:\ then copy to E:\

3. attach the database.

if online backup

3. you have to use Restore method in SQL server.

start SQL 2005 server, right click on database option-->select Restore database, select from device -->specify backup

Backup media~~> file, click on Add~~> select file (external HDD location), in To database -->specify name of database (like PRD,DEV your SAP database name), in option, give the proper path for the restore.

4. run STM tool.

Thanks

Ganesh

Re: Backup & Restore SQL Server 2005

Former Member — Sun, 10 Jul 2011 06:48:12 GMT

Dear Ganesh,

As per your advice, i have to try that Restore database from SQL server,

I am getting some error after add the database.

Error "The media family ondevice E:backup DEVDATA1.bkf" is incorrectly format. SQL Server cannot process this media.

RESTORE HEADER only is terminated abnormally.

Please advice me further.

Regards

Thomas.T

Re: Backup & Restore SQL Server 2005

Former Member — Sun, 10 Jul 2011 14:52:36 GMT

Hi Thomas,

You could check if the backup is not corrupted:

http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/c62dfa9c-dda3-44a3-95ba-1577f700fdfc

Regards,

Srikishan

Re: Backup & Restore SQL Server 2005

Former Member — Sun, 10 Jul 2011 15:40:29 GMT

Dear All,

Thank You for your guidance. I'll do that as per your Link.

then Let you know.

Regards

Thomas.T

Re: Backup & Restore SQL Server 2005

Former Member — Mon, 17 Nov 2014 09:33:21 GMT

This message was moderated.

Re: Backup & Restore SQL Server 2005

Former Member — Mon, 17 Nov 2014 18:10:27 GMT

What are your Source and Target DB versions ?

Re: Backup & Restore SQL Server 2005

Former Member — Tue, 18 Nov 2014 10:53:56 GMT

Please use the option Homogeneous system copy to build the new SAP Server using the Previous backup.

Thanks

asad