on 07-09-2011 1:55 PM
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
Please use the option Homogeneous system copy to build the new SAP Server using the Previous backup.
Thanks
asad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What are your Source and Target DB versions ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi Thomas,
You could check if the backup is not corrupted:
Regards,
Srikishan
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.