Configuring an SMS Environment

Posted on
Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone

These questions are derived from the Self Test Software Practice Test for Microsoft exam # 70-089 – Planning, Deploying, and Managing Microsoft Systems Management Server 2003

Objective : Configuring an SMS Environment
SubObjective : Upgrade from SMS 2.0 to SMS 2003

Single Answer, Multiple Choice

You are the SMS administrator of your company. The company network consists of a single SMS 2.0 SP4 site. The servers on the company network run Windows Server 2003, and all the client computers run Windows XP Professional. The network contains a SQL Server 2000 computer that stores SMS site database. SQL Server database replication is enabled for the SMS 2003 site database. You are planning to upgrade the existing SMS 2.0 SP4 site to the SMS 2003 SP1 site.

You want to test the SMS site database upgrade. You create a copy of the SMS site database that was created by using the SMS backup task. You restore the copy of the database on a test computer running SQL Server 2000 and run the Setup.exe /testdbupgrade <database name> command. The database upgrade test fails.

What should you do to ensure that the database upgrade test is run successfully?

  • Disable publishing on the SMS site database, and back up the SMS site database again.
  • Upgrade the SQL Server 2000 computer to SQL Server 2000 SP4.
  • Install an SMS site on the test computer.
  • Create a backup of the SMS site database by using the SQL Server Enterprise Manager.

Answer:
A. Disable publishing on the SMS site database, and back up the SMS site database again.

Tutorial:
You should disable publishing on the SMS site database and back up the SMS site database again. You must perform some preliminary tasks to ensure that the upgrade of the SMS 2.0 site to the SMS 2003 SP1 site progresses smoothly. It is recommended that you test the upgrade tasks in a test lab before implementing SMS 2003 in the production environment. You can use the Setup.exe /testdbupgrade SMS_<sitecode> command to test the SMS site database upgrade. The /testdbupgrade switch destroys data. Therefore, you should ensure that you use this setup option only on a copy of your SMS site database and avoid using this setup option in a production environment. You can use the SMS 2003 Deployment Readiness Wizard to determine the steps that should be followed to prepare your site hierarchy for an upgrade. The wizard normally runs during the upgrade process. The Setup.exe /testdbupgrade fails on SMS site databases that are restored from an SMS 2003 site database with SQL Server replication enabled. When SQL Server database replication is enabled for the SMS 2003 site database, the computer running SQL Server modifies the SQL tables that are included in the publication. Therefore, when you restore the database to another computer, the Setup.exe /testdbupgrade fails on that restored SMS site database. To ensure that the database upgrade test is run successfully, you should disable publishing on the SMS site database before backing up the SMS site database.

You should not upgrade the SQL Server 2000 computer to SQL Server 2000 SP4. The Setup.exe /testdbupgrade fails on SMS site databases that are restored from an SMS 2003 site database with SQL Server replication enabled, regardless of which version of SQL is used. Therefore, you should disable publishing on the SMS 2.0 site database before backing up the SMS site database. Upgrading the SQL Server 2000 computer to SQL 2000 SP4 will not ensure that the database upgrade test is running successfully.

You should not install an SMS site on the test computer. When you want to test the SMS site database upgrade, the test computer should be running the same version of SQL Server as that on which the SMS site database is stored. You do not need to install an SMS site on the test server. Installing an SMS site on the test computer will not ensure that the database upgrade test is running successfully.

You should not create a backup of the SMS site database by using SQL Server Enterprise Manager. You can use either the SMS backup task or the SQL Server Enterprise Manager to back up the SMS site database. Before taking a backup of the SMS site database by using the SQL Server Enterprise Manager, you should stop all SMS services on the SMS site server and the SQL server. The Setup.exe /testdbupgrade fails on SMS site databases that are restored with SQL Server replication enabled. Therefore, you should disable publishing on the SMS site database before backing up the SMS site database. Creating a backup of the SMS site database by using SQL Server Enterprise Manager will not ensure that the database upgrade test is running successfully.

Reference:
TechNet Home > Systems Management Server 2003 Concepts, Planning, and Deployment Guide > Part 4: Deployment > Chapter 14: Upgrading to SMS 2003 > Performing Site Upgrades > Preparing a Site for Upgrade

TechNet Home > Systems Management Server 2003 Concepts, Planning, and Deployment Guide > Part 3: Planning > Chapter 11: Planning an Upgrade > Upgrade Strategies > Determine the Effect of the Upgrade

TechNet Home > Systems Management Server 2003 Concepts, Planning, and Deployment Guide > Part 3: Planning > Chapter 11: Planning an Upgrade > Preparing to Upgrade

Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone
cmadmin

ABOUT THE AUTHOR

Posted in Archive|

Comment: