From C:\SM_Attachments to E:\SM_Attachments
If you have already moved the files to the new attachment location, then you will want to do a couple of things. But first, make sure you have a good backup of the database before doing anything and it is a good idea to copy the attachments to the new location before deleting them from the old location.
To change the file directory location for existing attachments:
1, Run the following SQL Query in MSSQL Management Studion (NOTE: Backup the DB before doing this!!):
SET AttachmentPath = 'New_Location'
WHERE AttachmentPath = 'Old_Location'
2. Test an existing Incident/Attachment to make sure it is accessible. (NOTE: This will only work if you have already copied all the attachments from the Old_Location to the New_Location.
Change the file directory location for new attachments:
1. Login to the ConfigDB and open/edit your Tenant.
2. Change the "Attachment Path" to the new location.
3. Save the Tenant change.