Chat now with support
Chat with Support

MessageStats 7.8.1 - Upgrade Guide

Moving the Database Files and Reattaching the Database

Now you must move the database data and transaction log files to a location on the new SQL server and reattach the database.

To move the database files
1
Navigate to SQL Server Data folder.
2
Move the data file and log file to the new SQL server location. As noted in the previous procedure, these files are normally named:
•
MessageStats.mdf
•
MessageStats.ldf
To reattach the database
1
In SQL Server Management Studio, right-click Databases and navigate to Tasks | Attach Database.
2
Click the browse (...) button.
3
Navigate to where the MessageStats.mdf and the MessageStats.ldf files now reside.
4
Select the MessageStats.mdf file and click OK.
The “Attach Database - [Servername]" dialog box displays the database information
5
Click OK.
A dialog box displays “Attaching database has completed successfully.”
6
Click OK and exit SQL Server Management Studio.

Updating Connections to the New Server

Now you must edit the values that point to the old SQL server and update them to point to the new SQL server.

•
To point the MessageStats Web Reports to the new SQL server, you must edit the QMSReports.udl file.
•
To point the MessageStats server (which hosts the scheduler service) to the new SQL server, you must edit the MessageStats server properties in the console.
To update QMSReports.udl file
1
On the computer that hosts the MessageStats Reports, navigate to the MessageStats installation directory.
By default, the installation directory path is C:\Program Files (x86)\Quest\MessageStats.
2
Double-click the QMSReports.udl file.
3
Select the Connection tab.
4
Select or enter the new server name (ServerName\Instance Name).
5
Click Test Connection to verify the connection to the new server.
6
Click OK.
To update the SQL server location in the MessageStats console
1
Open the MessageStats client console.
2
Right-click the MessageStats Server name in the treeview and select Properties.
The MessageStats server node is located directly under the MessageStats node in the tree.
3
Select the Database tab.
4
Click the browse (...) button for the Locate the database on the following SQL server option.
5
Select the new SQL server.
6
Click Apply and click OK.
7
Click the Database Management node and verify that the “Connected to” message displayed at the bottom right contains the correct SQL server name.

Upgrading MessageStats After the Database is Moved

If you are upgrading MessageStats after you have moved the database to a new SQL server, you must do the following:

1
Run the MessageStats installer on the new SQL server to upgrade the database version.
For information about upgrading the MessageStats database, see Upgrading a Distributed Installation with a Separate Database Server .
2
Run the MessageStats installer on the servers that host the MessageStats reports and MessageStats server (scheduler service, console, and task processors).
For more information about upgrading the reports and server, see 2. Upgrading the MessageStats Reports and the MessageStats Server .

 

Moving and Upgrading MessageStats

Moving and Upgrading MessageStats
•
About Moving a Complete MessageStats Installation
•
Moving a MessageStats Installation with No Installed Report Packs
•
Moving MessageStats with at least One Installed Report Pack — No Upgrade
•
Moving and Upgrading MessageStats with at least One Installed Report Pack
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating