Updating the maintenance plan after renaming the server
Before updating the maintenance plan, verify that you have has SQL Server Integration Services (SSIS) installed. SSIS is part of the typical SQL Server installation.
If you rename the GV STRATUS server, you must update the maintenance plan. Renaming the server does not alter the maintenance plan.
The maintenance plan update can be divided into three main sections:
Stage 1: Exporting the maintenance plan to a file
Stage 2: Updating the file with the new server name
Stage 3: Importing the modified plan
- Open SQL Server Management Studio (SSMS) on the server.
- Open a connection to the local Database Engine and to the local Integration Services. (Use the Connect drop down button in SSMS.)
- Locate the STRATUSMaintenancePlan under Integration Services | Stored Packages | MSDB | Maintenance Plans.
- Right-click on the maintenance plan to bring up the context menu, and select Export Package.
- Select File System in the Package Location drop-down list.
- Enter or browse to a desired location in the Package Path text box.
- Click OK and verify that the file was created by navigating to the specified location.
- Open the file in a text editor, such as Notepad.
- Replace all occurrences of the old server name with the new server name, and save the file.
- In SSMS, right-click on Integration Services Stored Packages| MSDB|Maintenance Plans.
- From the context menu, select Import Package.
- Specify the same path as you did in step 6.
-
If the modified maintenance plan has the same name as the
original, a warning is displayed indicating that the Maintenance Plan will be
overwritten. Click
OK.
Note: Do not import the package file (e.g. STRATUSMaintenancePlan.dtsx) into another maintenance plan.