A Library can be moved by moving the corresponding MDF, LDF files from their existing location to another location on the same computer.
Note: The default path for the database files for a library is C:\Program Files\Microsoft SQL Server\MSSQL10_50.AUTODESKVAULT\MSSQL\DATA.
- Select a library from the Libraries folder.
- Select Actions ► Move (or select Move from the right-click menu).
- On the Move Database Files dialog browse to the new location for the Data file (MDF) and Log file (LDF).
- Click OK on the browse dialog.
- Click OK on the Move Database Files dialog
- Select Yes on the prompt to proceed with the Move operation.
Note: MS SQL requires that the location where the database is being moved to must be on the same computer the where database is currently located.
MS SQL requires that the user under which SQL service is running have Full Control to the location to which the database is moved.
It is not necessary that both the MDF and LDF of a given library be at the same location.