Here is a link to a complete script for backing up your TestCaddy databases on a SQL server. Be sure to read the Readme.txt file in the zip file and follow instructions on changing the few configuration settings in the script. The script must be setup as a Scheduled Task on the box running SQL Server. It does the following:
  • Creates a backup of all TestCaddy databases on the specified SQL Server, and stores the files in a local location. The script backs up the TestCaddyMaster database and any TestCaddy Product Databases on the SQL Server.
  • If a remote location has been specified, the script copies the files to that location ready for backing up via your normal file backup strategy.
  • Deletes the backup files that are older than two weeks (note this can be changed).