1. Make sure all users are logged out of the MET/TEAM, MET/TEAM Customer Portal, and MET/TEAM Email Alerts web sites.
2. Stop the MET/TEAM web sites.
a. Click the Start button and select Control Panel > Administrative Tools > Internet Information Services (IIS) Manager. If Administrative Tools does not appear in the Control Panel window, change the View by setting in the upper right corner to Large icons or Small icons.
b. Expand the nodes in the Connections pane on the left until you see the METTEAM items under Sites.
c. Select the METTEAM item.
d. On the far right pane, click the Stop link in the Manage Web Site section.
e. Repeat this for the METTEAM Customer Portal and METTEAM Email Alerts sites.
f. Leave the Internet Information Services (IIS) Manager window open as (IIS) will needed later to start the web sites.
3. Delete the current MET/TEAM database.
WARNING: Deleting the
existing metteam database permanently
wipes out all data in the database! Do not proceed without first backing up the
current database unless the current database does not contain critical data
that is not found in the backup being restored!
a. Launch SQL Server® Management Studio and connect to the server. This shortcut is typically found in All Programs > Microsoft SQL Server 2008 R2.
b. In the left pane, expand the Databases node.
c. Right-click the metteam database and select Delete from the popup menu.
d. On the Delete Object screen, check the Close existing connections checkbox at the bottom of the screen and click OK to delete the database.
4. Restore the backup of the migrated MET/TEAM database.
a. In SQL Server® Management Studio, right-click the Databases node and select Restore Database.
i. On the Restore Database screen, enter metteam in the To database box.
ii. Select the From device option and click the “…”button.
1. On the Specify Backup screen, select the File option.
2. Click the Add button.
a. On the Locate Backup File screen, navigate to the directory where the .bak file is located, select the file and click OK.
3. Click OK on the Specify Backup screen.
iii. On the Restore Database screen, check the box in the Restore column in the grid and click OK.
5. Close SQL Server® Management Studio.
6. Start the MET/TEAM web sites.
a. In the Internet Information Services (IIS) Manager window, select the METTEAM item under the Sites node.
b. On the far right pane, click the Start link in the Manage Web Site section.
c. Repeat this for the METTEAM Customer Portal and METTEAM Email Alerts sites.
7. Close the Internet Information Services (IIS) Manager window
8. Launch the MET/TEAM web site and log in using one of your user accounts.