Other Topic Library Versions

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

  1. Open SQL Server Management Studio (SSMS) on the server.
  2. Open a connection to the local Database Engine and to the local Integration Services. (Use the Connect drop down button in SSMS.)
  3. Locate the STRATUSMaintenancePlan under Integration Services | Stored Packages | MSDB | Maintenance Plans.
  4. Right-click on the maintenance plan to bring up the context menu, and select Export Package.
  5. Select File System in the Package Location drop-down list.
  6. Enter or browse to a desired location in the Package Path text box.
  7. Click OK and verify that the file was created by navigating to the specified location.
  8. Open the file in a text editor, such as Notepad.
  9. Replace all occurrences of the old server name with the new server name, and save the file.
  10. In SSMS, right-click on Integration Services Stored Packages| MSDB|Maintenance Plans.
  11. From the context menu, select Import Package.
  12. Specify the same path as you did in step 6.
  13. 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.

Copyright © 2019 Grass Valley Canada. All rights reserved. GV STRATUS 6.8 gvtp_20190318_01:43:25