Client Management Suite

Want to recover the Recovery Solution cluster settings in the Notification Server database? This tip will tell you the method to do so.

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:
   • Cluster name, Recovery Solution database name, and database file locations must be the same.
   • An existing Recovery Solution database should be detached or deleted (in case backup is available).
   • 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 (old one) Recovery Solution Cluster GUID. Old cluster GUID can be found in:
   • 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
     
     

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
   
   

7. Refer to DBName, DBServer information to find proper cluster details in case if more than one Recovery Solution Cluster exists.
8. Replace variable value @oldGUID 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):
   • Use copy and paste to copy the script from this document to the Microsoft SQL Query Analyzer or SQL Server management Studio
   • Make sure Altiris database is selected from the drop-down list of the Query Analyzer.
   • 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 @oldGuid nvarchar(40)
 declare @newGuid nvarchar(40)

 --Replace GUIDs here
 set @oldGuid = '<GUID>'--Must replace with guid from RS_Clusters table found in the Notification Server database
 set @newGuid = '<GUID>'--Must replace with NSClusterGuid from VaultGroup table found in the Recovery database without the {}.

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