Changing the location of Acctivate SQL Server Database Files.

Detach the database within SQL Server Management Studio, move the database .mdf and .ldf files, then attach the database again using the new file path.

Move Acctivate SQL Server Database Files

Moving your database files to a different drive or partition should only be performed by a system administrator. You can use Microsoft SQL Server Management Studio in order to prepare the database to be moved.

We highly recommend you back up your databases before you proceed.

  1. Open Microsoft SQL Server Management Studio (SSMS) on the server, which is usually located on the Start menu, under All Programs -> Microsoft SQL Server
    • Please refer to this article if you don’t see Management Studio on your server
  2. When the login Screen appears, select the Instance” of SQL Server that Acctivate is running on (e.g. SERVER\ACCTIVATE).
  3. You will need to log in using SQL Server authentication using the “sa” account.  Please let us know if you do not know the SA password and need assistance.
  4. Expand the Databases folder on the left in Management Studio
  5. Right-click your company database (such as ACCTivate$Demo) and select Properties
  6. Select Files in the list and take note of the Path.
  7. Right-click ACCTivate$Demo database and select Tasks > Detach then click OK
    • The database will be no longer be listed on the SQL Server, but the data files will NOT be deleted
    • This allows you to copy the database files to a different directory on the server
  8. You can now COPY and PASTE the database files to the new directory
    • Move BOTH files for each database (e.g., ACCTivate$Demo_data.mdf and ACCTivate$Demo_log.ldf)
  9. Once you have moved the files, you will now need to reattach the files to SQL Server
  10. Right-click Databases in Management Studio and Select ‘Attach…’
  11. Click Add then Browse to the new directory and select your Database MDF file and click OK
  12. Click OK again to attach the database
  13. Repeat these steps for each of your databases. You should include the “Acctivate” database that exists here as well.

If you have an automated backup procedure set up, verify your backup is working properly.