Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

App Control: How to Migrate the DAS Database to a New Partition

App Control: How to Migrate the DAS Database to a New Partition

Environment

  • App Control Server: All Supported Versions
  • Microsoft SQL Server: All Supported Versions
  • Microsoft Windows Server: All Supported Versions

Objective

To move the DAS database to a different partition, when the SQL Server/Instance name have not changed.

Resolution

  1. Make a full backup of the current database.
  2. Log in to the application server hosting the Console as the Carbon Black Service Account.
  3. If an App Control Agent is installed on the server, temporarily move it into a Disabled Policy.
  4. Stop the App Control Reporter and App Control Server services.
  5. Open SQL Server Management Studio and connect to the database.
    • Use an account with explicit db_owner and dbo schema permission on DAS.
    • Group membership is not sufficient for the login, as groups cannot have default schema assigned.
    • The login account needs these permission and schema directly assigned.
  6. Expand Databases > right-click DAS > Properties > Files.
  7. Make note of the "File name" and "Path" locations > click OK
  8. Right-click on DAS > Tasks > click Detach > check Drop Connections > click OK
  9. Stop the SQL Server (Instance) service
  10. In Windows explorer, browse to the File Path from Step 7 and move the files (das.mdf, das_abinst.ndf, das_abtemp.ndf, das_events.ndf, and das_log.ldf) to the new partition.
  11. In SQL Server Management Studio, right-click on Databases > click Attach > specify the new location of das.mdf (Step 10)
  12. Stop the App Control Reporter and App Control Server services.
  13. Confirm Console access, and that Agents are connecting.

Related Content


Labels (1)
Tags (2)
Was this article helpful? Yes No
100% helpful (1/1)
Article Information
Author:
Creation Date:
‎11-20-2018
Views:
2361
Contributors