What are the challenges you face when working across database platforms? Take the survey
Options

SQLbackup.exe only

russellfoggrussellfogg Posts: 4
edited March 4, 2008 9:54AM in SQL Backup Previous Versions
Hi,

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

Thanks
Russell

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.