It is impossible to move the .ldf file only and leave the .mdf file on its original location, and vice-versa. Both .mdf and .ldf files must be on the same location (e.g. F:\databases\) when you re-attach it to the SQL instance.
In case you're not familiar with Microsoft SQL navigation, you may consult your database administrator.
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.