Archiver: How to Point to Another Server

Revision as of 19:55, 18 December 2009 by Docwikibot (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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)