How to restore MSSQL database to the same instance to a different database?
Due to various reasons or requirements, a restore of MSSQL database back to the same instance to a different database might be needed.
This different database will need to coexist with the original database being backuped.
For example: database "production-db1" is restored back to the same instance as "production-db1-test", and after the restore, the instance will contain both live database "production-db1" and restored database "production-db1-test".
This is quite a sensitive operation, if possible, please test this out with a dummy database until you are familiar with the operation or else the live database with the backuped data might be overwritten.
Procedure:
1. Select the saveset to restore and browse the restore selection
2. Select and check the database to be restored
3. Click on "Action" dropdown above and click "Rename"
4. MOST IMPORTANT STEP. In the "Rename" field, fill in the "different database" name. This needs not be already created. During the restore, this will be created. (If this is not being filled in, the restore will overwrite the existing live database)
5. In the "Relocate" filed, fill in the directory/folder location where you would like the mdf and ldf file of the "different database" to be restored to. (The directory must be already created and full permission of the directory and parent directory must be granted to the account used in the Netvault MSSQL Plugin and the MSSQL service account)
6. Click Next and proceed with the restore.
