The first step is the back up your MessageStats database on the existing SQL server.
2 |
Expand the Databases node. |
3 |
6 |
Ensure the Overwrite Media option is set. |
7 |
Click OK from the Backup Database window. |
Next, you must restore the MessageStats database on the new SQL server.
2 |
4 |
Under the Restore section of the Backup Database window, select the [From device] option. |
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. |
If the MessageStats database resides on a SQL cluster, create the groups in Active Directory.
1 |
Open SQL Server Management Studio and expand Security | Logins. |
2 |
3 |
4 |
Select Windows Authentication. |
5 |
For the Default Database, select MessageStats from the drop-down list. |
6 |
In the left hand column, click User Mapping. |
• |
9 |
Click OK. |
1 |
Open SQL Server Management Studio and expand Security | Logins. |
2 |
3 |
4 |
Select Windows Authentication. |
5 |
For the Default Database, select MessageStats from the drop-down list. |
6 |
In the left column, click User Mapping. |
• |
9 |
Click OK. |
Assign the following database roles to the new SQL account:
• |
You must also detach the database, in preparation for moving the database files to the new location.
3 |
4 |
Select the Files tab. |
6 |
Click Cancel to close the window. |
7 |
8 |
Click Clear if there are connections using this database. |
9 |
Click OK. |
10 |
Click Yes. |
11 |
Click OK. |
12 |
Click OK. |
© ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center