How to detach and reattach your database to the SQL Server ACT! instance

Summary

This article explains how to detach and reattach your database to the SQL Server ACT! instance.

Answer

If you need to copy or move your ACT! database files, before you copy, move or delete the database .adf and .ALF files, you need
to detach the database from the SQL Server ACT! instance.

If SQL error messages appear within ACT! after running the Repair, Rebuild and Fix options you may need to detach and reattach your ACT! database to the SQL Server ACT! instance.

This article explains how to do this and contains the following sections:

  • To detach your database from the SQL Server ACT! instance – You must complete this before you can move your database, or before you reattach the database to resolve SQL error messages.
  • To reattach your database – You must locate the .pad and .adf files associated with your database then delete the .pad file. You must then must open the .adf file to recreate the .pad file and reattach your database to the SQL Server ACT! instance.
To detach your database from the SQL Instance

1. Close ACT!, open the Windows Start menu then choose Run.

The Run window appears.

2. In the Open box, enter actdiag then click OK.

The ACT! Diagnostics window appears.

3. From the navigation bar, click Databases, select Database List then select the database name you want to detach.

The chosen database is highlighted.

4. To locate the DATABASE FILE LOCATION column, press the right arrow key on the keyboard, then note the path.

5. Right-click the rectangle to the left-hand side of the database name, choose Detach Database then click Yes.

A message appears confirming the database has been detached.

6. To return to the Windows desktop, click OK then open the File menu and choose Exit.

You have now detached your database from the SQL Server ACT! instance. You can now copy, move, or delete your .adf and .alf files. After you have copied or moved your database, you need to reattach your database.

To reattach your database

To delete the .pad file and locate the .adf file

Windows Server 2003/XP

Note: The default location of the .pad and .adf files is C:\Documents and Settings\User_Name\My Documents\ACT\ACT for Win 7\Databases. If your database files are in the default location, please proceed to step 4.

1. Right-click the Windows Start button then choose Search.

The Search Results window appears.

2. Complete the Search Results window as follows:

3. To start the search, click Search.

The search results appear in the right-hand pane.

4. Right-click the .pad file then choose Delete.

The .pad file is removed from the Search Results list.

Note: To locate the .adf file, repeat steps 1 to 3, replacing databasename.pad with databasename.adf.

5. Note the In Folder location of the .adf file then to close the Search Results window, open the File menu and choose Close.

The Windows desktop appears.

Windows 2000

1. Right-click the Windows Start button then choose Search.

The Search Results window appears.

2. Complete the Search Results window as follows:

3. To start the search, click Search.

The search results appear in the right-hand pane.

4. Right-click the .pad file then choose Delete.

The .pad file is removed from the Search Results list.

Note: To locate the .adf file, repeat steps 1 to 3, replacing databasename.pad with databasename.adf.

5. Note the In Folder location of the .adf file then to close the Search Results window, open the File menu and choose Close.

The Windows desktop appears.

To reattach the database to the SQL Server ACT! instance

1. Open ACT! then click Open Database.

The Open window appears.

2. Complete the Open window as follows:

3. To verify and update the database, click OK.

A confirmation window appears.

4. To complete the process and open your database, click OK.

The database opens.

You have successfully reattached your database.

For further advice or technical queries

Please contact us on:

01603 516350

enquiry@mintmis.com

www.mintMIS.com

Download the above article in PDF for FREE below