Relocating an MSSQL database to a new server (4046021)

Title: MSSQL relocating a database to another server through the Netvault MSSQL plugin
Date: 13/08/2002
NV Version:
OS Version: Windows
Application version:SQL 7/SQL 2000
Plugin version:4.x

Description: How to relocate an individual MSSQL database to a another server

Note that this method is NOT to be used for relocating a master database.

[1] .Establish the full path of the target sqlserver's data file location.
i.e. d:\program files\microsoft SQL server\MSSQL\Data

[2] 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.

[3] Select the desired item by clicking the box to the left of it (selected items will contain a green check).

[4] Once selected, right-click on the item and select Rename from the pop-up menu.

[5] 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. TARGET ).

[6] 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 sqlserver's data file location.
(e.g. d:\program files\microsoft SQL server\MSSQL\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] then submit the job.

IMPORTANT NOTE: Even if only renaming an item that is to be restored to it’s same original location, it is necessary to input the correct path in the Relocate to field. Otherwise, the restore will fail.