Chat now with support
Chat with Support

MessageStats 7.8.1 - Upgrade Guide

Backing Up the MessageStats Database

The first step is the back up your MessageStats database on the existing SQL server.

2
Expand the Databases node.
3
Right-click the MessageStats database and select Tasks | Backup Database.
6
Ensure the Overwrite Media option is set.
7
Click OK from the Backup Database window.

Restoring the MessageStats Databaseon the Destination Server

Next, you must restore the MessageStats database on the new SQL server.

2
Right-click the Databases node and select Tasks | Restore Database.
5
Click Select Devices.
6
Click Add and select the backup file that you created.
7
Click OK until the Restore Database window is displayed.
8
Click OK on the Restore Database window to restore the database.

Setting Security on the New SQL Server

Security groups are needed to assign rights to the MessageStats database on the new SQL server. You must create two groups, either local groups or global groups, named MessageStats Admin and MessageStats Web.

If the MessageStats database resides on a SQL cluster, create the groups in Active Directory.

2
Right-click Logins and select New Login.
3
Click Search and find the MessageStats Admin group. Click OK.
4
Select Windows Authentication.
5
For the Default Database, select MessageStats from the drop-down list.
9
Click OK.
2
Right-click Logins and select New Login.
3
Click Search and find the MessageStats Web group. Click OK.
4
Select Windows Authentication.
5
For the Default Database, select MessageStats from the drop-down list.
9

If SQL authentication is being used, you must create a SQL account on the new SQL server and assign the appropriate database roles.

Assign the following database roles to the new SQL account:

Detaching the Database

You must also detach the database, in preparation for moving the database files to the new location.

3
Right-click the Databases folder, select MessageStats and select Properties.
4
Select the Files tab.
6
Click Cancel to close the window.
7
Right-click the MessageStats database and select Tasks | Detach Database.
8
Click Clear if there are connections using this database.
9
10
Click Yes.
11
12
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating