BH In the new version of sql anywhere, the mirroring is done with sql statements rather than cmd commands. In the old case the commands could be automated with a .bat file. However, with the new version, what happens if the server gets restarted, all the mirroring settings have to be executed again manually? Or is there a way to automate their execution? Or am i missing something? Thanks Aron
asked 23 Dec '13, 13:41
In the "new" method, all of the mirroring configuration settings for the primary and mirror server are stored in the database - see sysmirrorserver, sysmirroroption, and sysmirrorserveroption tables. You do not need to execute the configuration settings each time you restart the database.
The "-xp on" command line switch indicates to the server that you want the configuration settings within the server tables to be used.