on 10-03-2008 11:24 AM
Hi,
How to restore the SBO_BACKUP(backup creyed by sytem by sheduling the backup) in to sap b1
Regards
srinivas
Dear,
For restoring backup file created by SQL server, please refer to note 557868 below:
Symptom
How to Restore the Database after a Backup has been performed?
Other terms
Backup, sQL, restore, database, enterprise manager, SAP Business One
Reason and Prerequisites
Restore the Database in the "Enterprise Manager".
Solution
To restore the Database after a Backup, please perform the following
steps:
1. You need to close SAP Business One first, otherwise the system will not be able to restore the Database
2. Now go to "START" in the taskbar
3. Choose "Programs"
4. Choose "Microsoft SQL Server" in the Drill Down Menu and then "Enterprise Manager"
5. Go to your Server by clicking on the Plus () Sign near "Microsoft SQL Server", "SQL Server Group" and the Plus () Sign with your own Server
6. Open "Databases" by clicking on the Plus Sign once again
7. Right click on the relevant "Database Name" (you can find the "Database Name" if you go into "Administration" and "Choose Company" in the Command Center. The "Database Name" is beside the "Company
Name" in the "Choose Company" window)
8. Choose "All tasks" in the Drill Down Menu, which appears after right clicking on the relevant "Database Name"
9. Choose "Restore Database" in the next Drill Down Menu
10. Check the box "From Device" and then press the button "Select Devices"
11. Click on the "Add" button
12. The box for "File name" is checked already
13. Using the ("...") button here, you can choose the Backup you want to do the Restoration from
14. Click on the "File name" once and it will come up in the white field for "File name"
15. Now click "OK" three times
16. Back in the "Restore Database" window go to the "Options" tab
17. Check here whether you have chosen the correct "Database Name" and check the box "Force restore over existing database"
18. Click "OK" to confirm your selections
19. The system is restoring the Database now
20. Please wait a moment until you get the message "Restore of Database 'Database Name' completed successfully"
21. Now you can click on "OK" to exit.
For DB2 server, please refer to note:858246/ 858996
Hope the informaion above could solve your issue.
Regards
Apple
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear,
In additionally, Is it possible to backup or restore to a shared or mapped drive on another machine other than the server where Microsoft SQL Server is running.
In order to do this the MSQL service has to run under a user account with networking rights in the shared or mapped drive. In order to archieve this do as follows:
o Go to Start => Settings => Control Panel => Administrative Tools => Services and find the MSSQLSERVER service.
o Right click the service and select properties.
o In the property windows select the Logon tab, the 'Local System Account' option should be selected by default.
o Change this to the 'This account' option and select or browse to find a user (It must be a user with administrator's rights in the local machine in order to start the MSSQLSERVER service) with relevant network permissions (read & write) on the shared or mapped drive where backup or restore is to be carried out.
o Stop and restart the service with the new credentials.
o While doing the backup or restore the UNC path must be used to reference the required file.
For example:
255.255.255.255 (IP address or name of the target
machine)\sample_folder (relevant folder with network
permissions)\sample_backup.BK (the new backup file to be created)
o Note: The mapped letter should not be used.
Hope it is useful for you
Regards
Apple
In the system schedule backup, the back up file will be stored in .BU file.
In the sql studio,
->select the database which has to be restored
->Rt.click on the selected database
->Go to tasks-Restore
->select the .BU file and follow the normal restore steps.
This will restore the default system back up.
I think this would help you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.