Learn how to migrate a database file to another drive, which can be helpful during these scenarios:
- Moving a file to another disk with larger capacity
- Default drive has ran out of space
- Database disk capacity can no longer be increased
This procedure only applies to Deep Security Manager (DSM) or Vulnerability Protection Manager (VPM) that uses Microsoft SQL as their database.
In case you're not familiar with Microsoft SQL navigation, you may consult your database administrator.
To move a database file:
- Stop the Deep Security Manager service or Vulnerability Protection Manager service.
- Log in to SQL Server in the SQL Studio and then back up the database.
- Right-click the DSM or VPM database and click Task, then click Detach.
- Tick the Drop Connection checkbox and click OK.
- On the SQL Studio, confirm that the database name is no longer existing in the Database list.
- Move the .mdf and .ldf files to another drive (e.g. F:\Databases\).
- On the SQL Studio, right-click the Databases and click Attach.
- Under Databases to attach, click Add.
- Browse for the Database file (.mdf) from its new location (e.g. F:\Databases\) and click OK.
- Verify the database details and location and click OK.
- On the SQL Studio, make sure the database name is back in the Database list.
- Start the Deep Security Manager service or Vulnerability Protection Manager service.
- Confirm that you can open the Deep Security Manager service or Vulnerability Protection Manager console.