How to move the MessageStats database files to a new drive.
To move the MessageStats Database files to a new drive on the same Server.
1. On the MessageStats server make sure no gatherings are running and close the MessageStats console.
2. Go to Start | Run type in services.msc and click OK.
3. Find the MessageStats Scheduler service and right click on it and select Stop.
4. On the SQL Server with the MessageStats database perform a full backup of the MessageStats database.
5. In SQL Server Management Studio Right click the MessageStats database and select Properties | Click the Files Page.
6. Make note of the Database file path and the file names for the mdf and ldf files and the name specified for the Owner.
7. Right click the MessageStats database, select Tasks | Detach
8. Using Windows Explorer and the file path noted above, copy the mdf and ldf files noted above to the new location.
9. In SQL Server Management Studio right click on the Databases node and select Attach | Browse to the location you copied the database files and select the MDF file and click ok.
10. Your MessageStats database should now be listed under the Databases node.
11. Right click on your MessageStats database and select properties | Click the Files Page.
12. Make sure the Owner is the same owner that you made note of above. If it is different change the the owner to the user account noted above.
13. On the MessageStats Server start the MessageStats Task Scheduler service.
