To back up the AS database on a remote/separate SQL Server you need to do the following:
- In AccountServer.Custom.config (in the install folder), add the following between the <appSettings> tags:
<add key="DisableDbBackups" value="False" /> - If the AccountServer.Custom.config file does not exist, create a new one that includes the following:
<?xml version="1.0" encoding="utf-8" ?>
<appSettings>
<add key="DisableDbBackups" value="False" /> </appSettings> - Stop the AccountServer service and add the following to the AccountServer's Settings.xml file:
<ServerBackupPath>UNC path to folder that the AS and SQL Server have full access to</ServerBackupPath>
E.g. <ServerBackupPath>\\SQLTestDB\DBBackup</ServerBackupPath>
Note: The <ServerBackupPath> and "DisableDbBackups" settings are needed on the Slave AccountServer too, if it is also running a separate SQL server instance. - Restart the AccountServer for the settings to take effect.
- Make sure that both the SQL Server and AccountServer services are running as a user that has full control of the specified network path.
- The servers can be running as users on the same domain, or alternatively will also function correctly if running with the same username and password.
For example:
Machine: SQLTESTAS
Role: AccountServer
Service: Attix5 AccountServer Service
Service User: .\Administrator
Password: Password123Machine: SQLTESTDB
Role: SQL Server
Service: SQL Server (MSSQLSERVER)
Service User: .\Administrator
Password: Password123 - When scheduled or manually triggered, the SQL Server will write out the Storage Platform database to the specified UNC path into the <UNC share>\Backup.zip\AS_Service\DBBackup directory as "BackupServer.bak".
Note:- Some versions of SQL Server do not support writing the database to a UNC path (e.g. SQL Express) - If using a separate SQL Server, ensure that it is able to write to UNC paths.
- If the server you are using does not support writing to UNC paths, you are strongly advised to run the AccountServer on the same machine as the SQL Server. SQL Express is available free from Microsoft, is fully compatible with Attix5 Pro, and functions correctly for local database backups which will then be replicated to StorageServers and Slave AccountServers for DR purposes.
- After configuring the database, confirm that this file exists.
- Once written out, the AccountServer will send Backup.zip and other database backup files to the appropriate StorageServers and Slave AccountServers.
Comments
0 comments
Please sign in to leave a comment.