Hi All

Next week im hoping to test moving the SQL instance from one server to another to test/document failover and how fast we can recover from backup.

The file zdm.xml from /etc/opt/novell/zenworks/datamodel is the one i hope to change to point to the new instance, for example if i change these fields in the zdm.xml file for each primary server would it be enough to repoint the server:-

<entry key="Server">server.domain.com</entry>
<entry key="Database">databaseinstance</entry>

If this is ok, where do i find the location of the database password?. I had to set this when i first installed the server. I understand that this password would probably stay the same within the sql backups we move about but im just wanting to cover everything before we attempt the test.

Many thanks
Julian