How to restore the SBo_Backup
How to restore the SBO_BACKUP(backup creyed by sytem by sheduling the backup) in to sap b1
Apple Liu replied
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.
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