New in the Community? Get started here

Schneider Electric Exchange Community

Discuss and solve problems in energy management and automation. Join conversations and share insights on products and solutions. Co-innovate and collaborate with a global network of peers.

Register Now
Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover the Exchange Community Top members of July 
Discover the latest features your community has to offer: register to the webinar here

Moving the WebReports SQL database to another hard drive

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:

  1. Start by backing up everything.
  2. Stop the reporting agent service (name: ReportingAgentService).
  3. Open SQL Server Management Studio and locate the database.
  4. Right-click on the database and select Tasks-->Detach.
  5. Locate the SQL database files (*.mdf and *.ldf) in Windows explorer.
  6. Cut or copy these files and move them to the desired location.
  7. Go back to SQL Management Studio and select the Databases folder.
  8. Right-click and select Tasks-->Attach database.
  9. When the dialogue opens up, locate the 'ADD' button and click on it.
  10. Browse to the database files' new location and click on OK.
  11. Restart the reporting agent service.
Tags (2)
Labels (1)
No ratings