You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You w

admin2009-05-19  32

问题 You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.
What should you do?

选项 A、Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.
B、Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.
C、Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.
D、Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.

答案A

解析 Explanation: Detaching and attaching databases is sometimes a useful technique for quickly moving a database from one computer to another. To move a database, or database file, to another server or disk the database must first be detached from the original server or disk; moved to the other server or disk and then attached on the server or disk. In addition the new location of the moved file(s) must be specified. The sp_detach_db stored procedure is used to detach the database and can run UPDATE STATISTICS on all tables before detaching the database while the sp_attach_db stored procedure is used to attach the database in its new location.

Incorrect Answers:
B: DTS can import data from a text file or from an OLE DB data source such as a Microsoft Access 2000 database into SQL Server. It can also export data from SQL Server to an OLE DB data destination. It provides for high-speed data loading from text files into SQL Server tables. However, it is not the fastest way to move a whole database from one server to another.

C: Before a database can be restored from a backup to a new location; the database must first be recreated in the destination as the backup holds only the data files that belong in the various tables. It does not hold the table definitions. This is not the fastest method to move a database.

D: The DISK INIT and DISK REFIT commands cannot be used to move a database from one server to another.

Note: DISK INIT and DISK REINIT are features that are used in a SQL Server 6.x. in SQL Server 6.x, DISK INIT is used to create database or transaction log devices to store the specified database or transaction log when DISK INIT followed either a CREATE DATABASE or ALTER DATABASE statement while DISK REINIT is used to restore device entries to appropriate system tables when the device entry was missing from sysdevices.

In SQL Server 2000 the CREATE DATABASE and ALTER DATABASE statements allow for the creation of separate data and log files. Both CREATE DATABASE and ALTER DATABASE create operating system files and databases in a single step. It is thus recommended that all references to DISK INIT should be removed in SQL Server 2000 and replaced with references to either CREATE DATABASE or ALTER DATABASE.
转载请注明原文地址:https://kaotiyun.com/show/IuhZ777K
0

最新回复(0)