HOW TO RESTORE AN MS-SQL DATABASE TO AN ALTERNATE LOCATION ( Updated on 5/19 )
This article describes one method for restoring a backed up MS-SQL database to an alternate location – a location other than the original location. We realize that there are many reasons for restoring an SQL database to an alternate location – to move it, or to test the restore.
Hopefully this article gives you enough insight into the process. If not, please contact us for further help with your specific needs.
Install the RBS Endpoint software on the computer to which you want to restore.
- Replace the 'backup.mdb' in to the Remote Backup folder with the one in the original Endpoint's Remote Backup folder.
Now follow the instructions below on the duplicate Endpoint machine:
1) Open the BackupAddict Endpoint software. Right-click the SQL icon and enter a bogus username and password that will not be able to login to SQL.
2) Restore the database using the standard Restore options.
3) You will get an error that it can't restore the file (because Remote Backup can't login to SQL Server). Do not close this error message. The software has placed a restored backup of the SQL database in your temp folder, usually C:\Temp\rbackup\SQL Server.
4) This file is a standard SQL Server backup database that you can restore through SQL Server on this or another machine if you want.
Use the following instructions to import the backup database:
Afterwards, you may edit the parameters in BackupAddict to be able to login to SQL.
You can also manually import the database back to SQL using a query or wizard in the SQL management express, if you want to. The file *.rbsql (downloaded file after restore) resides in the C:\Temp\Rbackup\SQL Server location.