Stratesave 7.0 - Network Database Backup

Stratesave 7.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. 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.

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