Restore an ACM database

Application Code Manager
 (ACM) uses a database to store reusable code. If ACM is being moved to a new database server or if the existing database server has incorrect ACM data, the backup made of the database can be restored to the database server so that all of the previous data is available.
IMPORTANT:
When restoring a remote database, the file location must be accessible with read and write access granted to the user account under which the remote database service runs.
Restoring an ACM database backup
onto a machine other than the one on which it was created
 will require database ownership to be set, because the user associated with the backed-up database does not exist in the new environment. If ownership is not set, then ACM users will continuously receive the following message: “Timed out waiting for the heart beat notification from the SQL Broker from within the ACM application. Please check the log file for details”.
The database administrator can set the database ownership. The database administrator uses the following script within either a SQL Management Studio query window or via a SQLCMD session:
ALTER AUTHORIZATION on DATABASE::[Database Name] TO [SQL User]
  • The [Database Name] section must be replaced with the ACM database name.
  • The [SQL User] section must be replaced with the name of the user who will be assigned ownership of the database.
Running the script ensures that you will no longer receives the timeout messages.
To restore an ACM database
  1. Open
    Application Code Manager
    , in the main menu, click
    TOOLS > Database Manager
    .
  2. In
    Server name
    , select the computer name and
    SQL Server
     instance from the dropdown list or type a computer name and
    SQL Server
     instance in the following format:
    <Computer name>\<
    SQL Server
     instance>
  3. In
    Log on to the server
    , use Windows Authentication or type the
    User name
     and
    Password
     to use to authenticate the connection to the
    SQL Server
    , then click
    Connect
    .
    Status
     updates to
    Connected
    .
  4. In
    Specify the database
    , select the name of the ACM database on which you want to restore the data.
    TIP:
    If you are restoring databases to a new database server or if the database is not present on the database server, create the database before restoring the data to it.
  5. In
    Actions
    , select
    Restore database
     and then click
    Execute Recovery
    . The
    Selected database backup to restore
     dialog opens.
  6. Select the database backup file (.bak) to restore and then click
    Open
    .
  7. The
    Confirm database restore
     dialog opens warning you that the current database will be overwritten and asking you if you are sure you want to restore the database.
    Click
    Yes
     to confirm the restoration process.
  8. Once the database is restored, an
    Action completed successfully
     message displays. Click
    OK
    .
  9. Click
    Close
     to close
    Database Manager
    .
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal