Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from D. Caddick on Jul 17 at 3:50 AM Hi sap,
The restore steps are fully described in the Microsoft SQL Server online books. You use the SQL Server Management Studio.
1. Open SQL Server 2005 Management Studio.
2. Connect to the appropriate server.
3. Expand Databases.
4. Right-click the desired database, Select Tasks, Restore and select Database.
5. The Restore Database window will appear.
6. Ensure that the correct database name appears in the To database field. If not, select it from the dropdown.
7. Under Source for restore, select the From device radio button.
8. Click the button next to the textbox to select the device to restore from.
9. The Specify Backup window will appear.
10. Click Add and locate and select the backup file from the Locate Backup File Window. Click OK.
11. Under Select the backup sets to restore, select full
12. In the left pane, select Options.
13. Under Recovery state, ensure that the Restore with Recovery radio button is selected.
14. Click OK to begin restoring the database.
15. Once the restore is complete, a notification box will appear. Click OK to close the box. You have now restored your database to the date of your backup.
You can search the internet for more detail.
Regards
| | | ---------------Original Message---------------
From: sapbasis25
Sent: Wednesday, July 16, 2014 2:28 PM
Subject: How To Restore Data In Sap Steps
Hi
Mine is windows 2003 r2,sqlserver 2005,sap ecc 6.
Last week my sap data base raid 5 three hard disk has been gone,
so now my sap is not starting. I have a back up of two months back in hard disk in .bak format.
What are the steps to follow to restore the data?
I have reconfigured raid 5 again.
My usr sap path files and log file are there in drives but my sap data base is full empty it has not recovered single file after raid 5 has been done with new and old hard disks configured.
So what I have I have to do now?
Please guide me.
Thanks
sap |
| Reply to this email to post your response. __.____._ |   _.____.__ |
