SQLbackup.exe only

russellfogg

Hi,

Is there a SQLbackup distribution exe available rather than having to use the full SQL toolkit exe?

Thanks
Russell

petey

If you want to use only extended stored procedures to backup and restore, and do not want to use the GUI at all, you can deploy and install SQBServerSetup.exe on your servers. This installs the SQL Backup Agent service, the extended stored procedure library and registers the extended stored procedures on SQL Server. You would also need to deploy and run ProductActivation.exe to register SQL Backup on those servers. Both these files (SQBServerSetup.exe and ProductActivation.exe) can be found in your SQL Backup installation folder.

If you don't want to have to install anything to backup and restore, you can use the command line interface of SQL Backup (SQLBackupC.exe). You would need to deploy this file together with the compression library (zlib1.dll). Again, you would also need to deploy ProductActivation.exe to be able to register and activate SQL Backup. You can find SQLBackupC.exe and zlib1.dll on any existing SQL Backup server components folder e.g. C:\Program Files\Red Gate\SQL Backup\(LOCAL).

If you do decide to use only SQLBackupC.exe, you would also need to download and install SQL Server Compact 3.1. SQL Backup stores backup and restore history data in a SQL Server Compact database. If SQL Compact is not installed, backups and restores can still be performed, but a warning is raised each time indicating that the local datastore could not be opened.

There aren't readily downloadable versions of the above files. You would need to install SQL Backup on at least one server, and get the above files from the SQL Backup installation folder.