Hello, in this article I will go over how to restore / refresh a database from a backup. This is helpful if you are restoring production database or refreshing a sandbox.
This is handled through Microsoft SQL Manager and not generally supported by Navigator or SAP.
The following article by Microsoft explains how to do it;
If you have the following error while working on it:
- Set the path to restore the file.
- Click "Options" on the left hand side.
- Uncheck "Take tail-log backup before restoring"
- Tick the check box - "Close existing connections to destination database".
- Click OK.
*You will need to use a different name for the database if a previous version exists. You can choose to overwrite an existing database by going to the Options tab "Overwrite"