Warning
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.
Issue
The database files used by the WebReports SQL database need to be moved to another location.
Product Line
EcoStruxure Building Operation
Environment
- WebReports
- SQL Server
Cause
There are numerous reason for wanting to do this, but the most common reason is that there is not enough space on the disk where the WebReports databases are located. 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.
Resolution
To move the database files, follow this process:
- Start by backing up everything.
- Stop the reporting agent service (name: ReportingAgentService).
- Open SQL Server 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 reporting agent service.
