How do I copy an existing ClockWork database to another machine?
Solution You may need to copy your ClockWork database to another machine if you upgrade your hardware, or if you are upgrading from Sql Server 2000 to 2005. There are different ways of copying the database over – this article outlines a method that involves backing up the existing database and then restoring it to the new machine. The destination machine should already have a version of Sql Server installed on it. 1. Create a backup of your existing ClockWork database. This can be done using Enterprise Manager or Sql Server Management Studio, or by using a sql script. Enterprise Manager / Sql Server Management Studio • Expand the database node for your database server, then expand the “Databases” node • Right-click on the ClockWork database and choose “All Tasks-Backup database” • Enter a descriptive name in the “Name” field • Ensure the “Backup to:” listing is empty and click the “Add” button • Select “File name” and click the “…” button, then choose a folder and filename for the ba
