cancel
Showing results for 
Search instead for 
Did you mean: 

Backup & Restore SQL Server 2005

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

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

Thanks

asad

Former Member
0 Kudos

What are your Source and Target DB versions ?

Former Member
0 Kudos

This message was moderated.

ganesh_borase2
Participant
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Thomas,

You could check if the backup is not corrupted:

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

Regards,

Srikishan

Former Member
0 Kudos

Dear All,

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

then Let you know.

Regards

Thomas.T