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