Backup and Migrate the SQL Database to a New Location

Use this article to migrate the SQL database from one HDD location to another. Perform these steps for all the databases (deployment and repositories).

1. Let impacted users know that during this process, all Synergize users and applications will be disconnected.

2. Keep the database and schema names the same.

3. Stop Synergize Connection Service (SCS) before starting the process.

   1. Open Synergize Enterprise Management Console (EMC) as admin.

      

   2. Click SCS > Stop.

      

4. Back up all databases before you perform the steps below in case something goes wrong. To back up the database:

   1. Open Microsoft SQL Management Studio.

   2. Right-click the database and select Tasks > Backup.

      

   3. Click Add and select the directory where the file needs to be stored.

   4. To start the process, click OK.

      

5. The default location where databases are stored after the backup process:

   C:\ProgramFiles\MicrosoftSQLServer\MSSQL12.SQLEXPRESS\MSSQL\Backup

6. Locate the default location where databases are stored on the live system, for example:

   C:\ProgramFiles\MicrosoftSQLServer\MSSQL12.SQLEXPRESS\MSSQL\DATA)

7. After creating a successful backup, detach the database in Microsoft SQL Management Studio by right-clicking the database and then selecting Tasks, Detach.

   

8. Select the Drop option if all the active connections need to be stopped while the detach process is on. Click OK to detach the database.

   

9. After the database has been detached, locate the database files again and move all files to the appropriate new location.

10. Open Microsoft SQL Management Studio again and right-click the Databases node and choose Attach in the pop-up menu.

    

    1. Locate the new directory. All the database files in that directory are listed.

    2. Click Add and select the database files to attach. Click OK.

       

11. When the process is complete, start the Synergize Connect Service.

    1. Verify that all database repositories are accessible prior to letting users back into Synergize.

    2. Start SPS and all other application services.