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
- Make a full backup of the current database.
- Log in to the application server hosting the Console as the Carbon Black Service Account.
- If an App Control Agent is installed on the server, temporarily move it into a Disabled Policy.
- Stop the App Control Reporter and App Control Server services.
- 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.
- Expand Databases > right-click DAS > Properties > Files.
- Make note of the "File name" and "Path" locations > click OK
- Right-click on DAS > Tasks > click Detach > check Drop Connections > click OK
- Stop the SQL Server (Instance) service
- 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.
- In SQL Server Management Studio, right-click on Databases > click Attach > specify the new location of das.mdf (Step 10)
- Stop the App Control Reporter and App Control Server services.
- Confirm Console access, and that Agents are connecting.
Related Content