Migrating the DAS Database to a New Partition

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

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

Environment

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

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.

Additional Information

If moving the DAS database to a new SQL instance use this article.