Question 1) Microsoft SQL Server 2000 Enterprise

Posted on
Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone

Objective : Creating SQL Server 2000 Databases
SubObjective : Attach and detach databases.
(Single Answer Multiple Choice)

 

You are the SQL administrator for TriState Communications (TSC). TSC maintains a very large technical support database, named TechSupport, which is used to store all technical support calls and solutions. TSC’s call center is being moved from the Charlotte office to the Atlanta office. All servers for TSC are members of the same Windows 2000 domain named TSCDom.

 

Currently, the database resides on a SQL Server 2000 computer in Charlotte, named CharSQL. However, due to the slow communication connection between Charlotte and Atlanta, you decide to move the database to a SQL Server 2000 computer in Atlanta, named AtlSQL. The TechSupport database uses Windows Authentication.

 

You detach the database using the sp_detach_db system stored procedure. You move the primary file, the 20 secondary files, and the transaction log file to AtlSQL.

 

What should you do next?

 

 

  1. Rebuild the registry on AtlSQL.
  2. Rebuild the master database on CharSQL.
  3. Rebuild the registry on AtlSQL and CharSQL.
  4. Rebuild the master database on AtlSQL and CharSQL.
  5. Attach the database to AtlSQL using the sp_attach_db system stored procedure.
  6. Attach the database to AtlSQL using a CREATE DATABASE statement with the FOR ATTACH clause.

 

Answer:
F. Attach the database to AtlSQL using a CREATE DATABASE statement with the FOR ATTACH clause.

Tutorial:
You should attach the database to AtlSQL using a CREATE DATABASE statement with the FOR ATTACH clause. If more than 16 files must be specified, you should use a CREATE DATABASE statement with the FOR ATTACH clause.

You should not rebuild the registry on either of the computers. This solution is drastic. If proper backups were not complete, this solution could actually cause damage to the database. This utility should only be used when absolutely necessary. If the proper detachment and attachment process is followed, any changes to the registry will be properly implemented.

You should not rebuild the master database on either of the computers. This solution is drastic and could actually cause damage to databases or database access if backups were not just completed. This utility should only be used when absolutely necessary. If the proper detachment and attachment process is followed, any changes to the master database will be properly implemented.

You should not attach the database to AtlSQL using the sp_attach_db system stored procedure. This is the normal procedure in most instances. However, when there are more than 16 files to be specified in the attachment, you should use the CREATE DATABASE statement using the FOR ATTACH clause.

Reference:
1. SQL Server Books Online – SQL Server Architecture
– Databases – Modifying a Database – Attaching and Detaching a Database

2. SQL Server Books Online – Transact-SQL Reference
– CREATE DATABASE

 

These questions are derived from the Self-Test Software Practice Test for Exam # 70-228 – Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition .

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:

Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>