Potential for Data Loss: The steps detailed in the resolution of this article may result in a loss of critical data if not performed properly. Before beginning these steps, make sure all important data is backed up in the event of data loss. If you are unsure or unfamiliar with any complex steps detailed in this article, please contact Product Support Services for assistance.
The database files used by the Web Reports SQL database needs to be moved to another location
There are numerous reason for wanting to do this, but the most common reason is that there is not enough space on the disk SQL is installed on. By moving to another disk this will allow space for future expansion.
Note that this article only describes how to move the database files to another harddrive. The SQL server and database files must still be on the same PC where WebReports is installed.
The process is fairly simple:
- Start by backing up everything.
- Stop the StruxureWare reporting agent service.
- Open SQL Management Studio and locate the database.
- Right-click on the database and select Tasks-->Detach.
- Locate the SQL database files (*.mdf and *.ldf) in Windows explorer.
- Cut or copy these files and move them to the desired location.
- Go back to SQL Management Studio and select the Databases folder.
- Right-click and select Tasks-->Attach database.
- When the dialogue opens up, locate the 'ADD' button and click on it.
- Browse to the database files' new location and click on OK.
- Restart the Struxureware Reporting agent service.