Stratesave 6.0 - Network Database Backup

Stratesave 6.0 Organized Backup Program Help Files

Network Database Backup

Stratesave supports databases backed up remotely. This works even if the server Software is not installed. For example a Windows Vista or XP Professional can fully backup a Windows 2008 or 2003 Server with SQL and Exchange Server databases. Administrator access is needed for Remote backup of SQL or Exchange Server.

SQL Server

For network backup of SQL Server, there are 2 possible modes: Using a remote process, or remote SQL Server function. This can be selected in SQL Server Backup Settings (in left pane under Settings). The remote process uses more overhead, but works sometimes where remote SQL functions do not, because SQL Server backup is started locally on the machine with SQL Server. Per default, remote SQL Server function is used.

Additional info on remote SQL Server function: Stratesave uses ODBC32 driver, which is included with Windows. It is not always possible to provide remote access username/password, so username/password on Stratesave backup computer should match with SQL server. Also the SQL Server must be configured for remote TCP/IP access, and the backup Server where Stratesave is run should have actual version of SQL client connectivity (MDAC) or the latest Windows service pack installed. There are also firewall port settings to be configured for remote SQL Server access (TCP port 1433, UDP port 1434, program sqlservr.exe, see SQL Server documentation for details).

Additional info on remote process: This sometimes does not work if the SQL Server runs under System account, where Access is denied. If this happens, try running SQL Server under a different account, or use remote SQL Server function.

Exchange Server

For network backup of Exchange Server, there are 2 possible modes: Using a remote process, or remote Exchange Server backup function. This can be selected in Exchange Server Backup Settings (in left pane under Settings). The remote process uses more overhead, but works sometimes where remote Exchange functions do not, because Exchange Server backup is started locally on the machine with Exchange Server. Per default, remote process is used for restore, full backups and differential backups, but not for the very frequent incremental database backups.

Additional info on remote Exchange Server function: Stratesave uses EDBBCLI.DLL for Exchange Server 5.5, ESEBCLI2.DLL for Exchange Server 2007/2003/2000 (ESE98). These dlls don't come with Windows, but they can be copied from Exchange server to backup server (\Windows\system32 or Stratesave program directory). It is not possible to provide remote access username/password, so username/password on Stratesave backup computer should match with Exchange server. For remote backup of Exchange Server 2007/2003/2000 selecting server with IP-address currently does not work, so servername must be specified instead of server's IP-address. There are also firewall port settings to be configured for remote Exchange Server access. For Exchange Server 2007, remote backup of Exchange Server must be enabled on the Exchange Server computer. Create registry DWORD Value HKLM\System\CurrentControlSet\Services\MSExchangeIS\ParametersSystem\Enable Remote Streaming Backup, set it to value 1. If the backup computer where Stratesave runs is 32-bit, but the Exchange Server is 64-bit, copy ESEBCLI2.DLL from 32-bit Exchange version to backup server. Similarly, if Exchange Server is 32-bit but Backup Server is 64-bit, 64-bit ESEBCLI2.DLL from 64-bit Exchange installation is required on backup Server. Use the latest ESEBCLI2.DLL from Exchange Server 2007 for backup/restore of Exchange Server 2007.

If problems occur during remote database backup or restore, please check first that logged in username/password has remote Administrator access on the remote computer to be backed up or restored. Also check for Eventlog-messages on SQL/Exchange Server.

Stratesave Help Files