cancel
Showing results for 
Search instead for 
Did you mean: 

How to restore the SBo_Backup

Former Member
0 Kudos

Hi,

How to restore the SBO_BACKUP(backup creyed by sytem by sheduling the backup) in to sap b1

Regards

srinivas

Accepted Solutions (1)

Accepted Solutions (1)

former_member708266
Contributor
0 Kudos

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

former_member708266
Contributor
0 Kudos

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

Answers (1)

Answers (1)

msundararaja_perumal
Active Contributor
0 Kudos

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.