Creating a new default device other than master  Adding secondary companion to sysservers

Chapter 12: Configuring Adaptive Server for Failover on Windows

Adding the primary companion as a local server

Use sp_addserver to list the local server as the local server in sysservers using the network name specified in the sql.ini file. For example, if the companion MONEY1 uses the network name of MONEY1 in the sql.ini file, enter:

sp_addserver MONEY1, local, MONEY1

You must restart Adaptive Server for this change to take effect.





Copyright © 2005. Sybase Inc. All rights reserved. Adding secondary companion to sysservers

View this book as PDF