Moving your data to a new drive

Use this procedure if you want to move all your Sage 100 Contractor data to a different drive on the same computer. (For example, you would do this if you want to host your data on a faster, bigger drive than the one you are currently using.)

To move your data to a new drive:

1. Start Database Administration and connect to your current SQL Server instance.

2. Click Server Management > Move Data to New Drive.

   The Move Data to New Drive tab displays the letter representing the current drive.

3. Fill out the fields on the Move Data to New Drive tab:

   1. Click [Select New Data Drive].

   2. In the Select Data Location window, select (highlight) the drive where you want to move your data from the list. The drive must be formatted as NTFS and have at least three times the available space as the data you want to move.

      You cannot select a removable drive.

      Note: The Select Data Location window displays the local, fixed drives on your computer and shows information, such as the drive name and the amount of available space, for each one.

   3. Make a note of the drive you selected so that you can update your maintenance and backup schedules.

   4. Click [OK].

      You are returned to the Move Data to New Drive tab.

4. Click [Move Data].

   If any users are connected to the database, you receive a message. You must terminate their connections before you can continue.

   If you change your mind about moving your data (for example, if you do not want to terminate user connections without notice), click [Cancel], and then click [OK] at the message asking you to confirm that you do not want to move your data.

   If the program cannot relocate your data, you receive an error message, and the program returns your data its state before you attempted to move it.