Steps to recover the Recovery Solution cluster settings in the Notification Server database

Article:HOWTO9247  |  Created: 2008-07-14  |  Updated: 2012-06-26  |  Article URL http://www.symantec.com/docs/HOWTO9247
Article Type
How To


Question
 

What are the steps to recover the Recovery Solution cluster settings in the Notification Server database?

Answer
 

Applies to RS version 6.2.x. Should not be used with RS 7.0.x and 7.1.

Steps below require operational knowledge of the SQL Enterprise Manager. Before proceeding, make sure that there are no jobs currently running on the Recovery Server and stop the Altiris Recovery Solution Server services. Close the Altiris Console as well.

 

  1. On a fresh Notification Server install Recovery Solution of a correct version, Recovery Solution version can be found in Recovery Solution client registry [HKEY_LOCAL_MACHINE\SOFTWARE\Altiris\eXpress\Recovery Solution Agent]Product Version =
  2. Create new Recovery Solution Cluster with same attributes as original one:
    1. Cluster name, Recovery Solution database name, and database file locations must be the same.
    2. An existing Recovery Solution database should be detached or deleted (in case backup is available).
    3. Important: Do not install Recovery Solution server yet.
  3. Replace new Recovery Solution database with the original one by either recovering an older Recovery Solution database from the SQL DB backup (overwriting the recently created one) or attaching the old Recovery Solution database to the SQL Server.
  4. Retrieve original Recovery Solution Cluster GUID. Original cluster GUID can be found in:
    1. Original RS database by running SQL query:

      SELECT NSClusterGuid FROM dbo.VaultGroup
      Recovery Solution client registry:

      [HKEY_LOCAL_MACHINE\SOFTWARE\Altiris\eXpress\Recovery Solution Agent]ClusterGUID

       
    2.  
  5. Replace variable value @newGUID in the script given at the end of this document with the Recovery Solution cluster GUID discovered at step 4.
  6. Retrieve the new Recovery Solution cluster GUID from the current Notification Server database (the one belongs to new cluster created at step 2.) New cluster GUID can be found in by using the Notification Server database (Altiris by default) by SQL query:

    SELECT Guid, DbServer, DbName, Version FROM dbo.RS_Clusters

    Refer to DBName, DBServer information to find proper cluster details in case if more than one Recovery Solution  Cluster exists
  7.  
  8. Replace variable value @originalGUID in the script given at the end of this document with the Recovery Solution cluster GUID discovered at step 6.
  9. Execute the modified script found below against Notification Server database which will populate the Notification Server database with the original Recovery Solution Cluster settings (GUID):
    1. Use copy and paste to copy the script from this document to the Microsoft SQL Query Analyzer or SQL Server management Studio
    2. Make sure Altiris database is selected from the drop-down list of the Query Analyzer.
    3. Make sure Altiris Console is closed while you execute the script.
  10. Install Recovery Solution server agent and check if clients can communicate to the new server

The SQL script:

declare @originalGuid nvarchar(40)
declare @newGuid nvarchar(40)

--Replace GUIDs here
set @originalGuid = '<GUID>'  --Must replace with guid from RS_Clusters table found in the Notification Server database. See Step 8
set @newGuid = '<GUID>' --Must replace with NSClusterGuid from VaultGroup table found in the Recovery database withouth the {}. See Step 5

--begin transaction
update Evt_NS_Item_Management set ItemGuid = @newGuid where ItemGuid = @originalGuid
update Evt_NS_Item_Management set ItemGuid = @newGuid where ItemGuid = @originalGuid                              
update Item set Guid = @newGuid where Guid = @originalGuid
update ItemNameCache set ItemGuid = @newGuid where ItemGuid = @originalGuid                                                                                       
update ItemPresentation set Guid = @newGuid where Guid = @originalGuid
update ItemPresentation set BaseGuid = @newGuid where BaseGuid = @originalGuid
update ItemReference set ChildItemGuid = @newGuid where ChildItemGuid = @originalGuid
update ItemReplication set ItemGuid = @newGuid where ItemGuid = @originalGuid                              
update ItemResource set Guid = @newGuid where Guid = @originalGuid
update ResourceFolder set ResourceGuid = @newGuid where ResourceGuid = @originalGuid
update RS_Clusters set Guid = @newGuid where Guid = @originalGuid
update String set BaseGuid = @newGuid where BaseGuid = @originalGuid
update StringCacheRN set BaseGuid = @newGuid where BaseGuid = @originalGuid
 

 

 

 


Legacy ID



43098


Article URL http://www.symantec.com/docs/HOWTO9247


Terms of use for this information are found in Legal Notices