Title: Restoring a named MSSQL instance to a new server
Date: 10/06
NV Version: 7.4.x
OS Version: Windows
Application version:MSSQL7/MSSQL 2000
Plugin version: 4.1.x
Description: Instructions for restoring a named MSSQL server instance to a new server.
Prerequisites:
Both Source and Target servers must have the same version of MSSQL server installed, with identical installation and data storage paths.
In order to restore a NAMED instance of MSSQL server to a server, a new instance of with the same name must already exist (without user data).
IE. if you are restoring a ROTTERDAMDB02/SQL02 MSSQL instance to the server TESTBCK - then there must be a TESTBCK/SQL02 instance already created.
Backup:
there are no special considerations for the backup process.
Restore:
Before restoring user data from the named instance, you will need to restore the master database to the target:
[1] From the Restore Selections window, drill down to the desired MS-SQL APM backup saveset.
Open the the saveset (by double-clicking on it) to reveal the database items contained within.
[2] Select the MASTER database clicking the box to the left of it.
[3] Once selected, right-click on the item and select Rename from the pop-up menu.
[4] The Restore Rename dialog box will appear.
Click the checkbox to the left of the Rename to field in order to activate it.
Input the desired new name for the selected item (i.e. SQL02 - note this is used only for the temporary rename of the file).
[5] Click the checkbox to the left of the Relocate to field in order to activate it.
Type in the path to the directory where the item is to be restored. This is the full path of the target MSSqlserver's data file location.
(e.g. C:\Program Files\Microsoft SQL Server\MSSQL$SQL02\Data\)
[6] Click on OK to commit the change and return to the Restore window.
The rename will be displayed with the selected data.
[7] Select the restore options tab & enter the target instance name into the target instance field (e.g. TESTBCK\SLQ02)
[8] Click the Target Client tab and select the desired Client Server from the list displayed. (e.g. TESTBCK)
[9] Then submit the job.
IMPORTANT NOTE: Even if only renaming an item that is to be restored to its same original location, it is necessary to input the correct path in the Relocate to field. Otherwise the restore will fail.
Once the restore job has completed :
[1] shutdown the target mssqlserver
[2] rename the orginal master database files from:
master.mdf
mastlog.ldf
to:
OLD.master.mdf
OLD.mastlog.ldf
[3] rename the restored master database files from:
SQL02_master.mdf
SQL02_mastlog.ldf
to:
master.mdf
mastlog.ldf
[4] restart the target mssqlserver
Once the master database has been restored, you can then proceed with restoring the individual user databases:
[1] From the Restore Selections window, open down to the desired MS-SQL APM backup saveset.
Open the the saveset (by double-clicking on it) to reveal the database items contained within.
[2] Select the desired item by clicking the box to the left of it (selected items will contain a green check).
[3] Once selected, right-click on the item and select Rename from the pop-up menu.
[4] The Restore Rename dialog box will appear.
Click the checkbox to the left of the Rename to field in order to activate it.
Input the desired new name for the selected item (i.e. TESTBCK ).
[5] Click the checkbox to the left of the Relocate to field in order to activate it.
Type in the path to the directory where the item is to be restored.
That is the full path of the target sqlserver's data file location.
(e.g. C:\Program Files\Microsoft SQL Server\MSSQL$SQL02\Data\)
[7] Click on OK to commit the change (or Cancel to abort) and return to the Restore window.
The rename will be displayed with the selected data .
[8] Select the restore options tab & enter the target instance name into the target intance field
[9] Click the Target Client tab and select the desired Client Server from the list displayed. (i.e.SITH)
[10] Submit the job.
IMPORTANT NOTE: Even if only renaming an item that is to be restored to its same original location,
it is necessary to input the correct path in the Relocate to field. Otherwise, the restore will fail.
