Archiver: How to Point to Another Server

From DocWiki

Revision as of 19:55, 18 December 2009 by Docwikibot (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Archiver: How to Point to Another Server

Problem Summary The Archiver is pointing to one database server (DAW2), and you want to point to another database server (DAW4, which is an exact copy of DAW2) without losing data that is already archived and without causing duplicate entries.
Error Message None.
Possible Cause You need to change the database server to which the Archiver is pointing.
Recommended Action 1. Open Microsoft SQL Server management Studio

2. Connect to the Archiver Server.

3. Navigate to Archiver Server > Server Objects > Linked Server.

4. Right-click on Linked Servers and click New Linked Server.

  • In Linked Server, enter <name of new hds server>.
  • For Server Type, select SQL Server.

5. Click OK.

6. Update the ServerName column in the Archiver t_Connection table by replacing the old value with the name of new link server.

Release Release 7.5(x)
Associated CDETS # None.

Rating: 0.0/5 (0 votes cast)

Personal tools