首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You w
You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You w
admin
2009-05-19
21
问题
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
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
Self-recommendationWriteane-mailofabout100wordsbasedonthefollowingsituation:Youwanttoapplyforapart-ti
YouarepreparingforanEnglishtestandhaveorderedareferencebookfromabookstore.Afteryoureadthebook,youfoundtha
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
Americanfarmershavebeencomplainingoflaborshortagesforseveralyearsnow.Givenamulti-yeardeclineinillegalimmigrati
Notlongago,chiefexecutiveofficers(CEOS)werelandedasheroes,leadersofthebraveneweconomy.BillGatesandJackWelchw
InParagraphs1and2,thetextshowsPTK’s______.Skepticalobserversbelievethatancestrytestingfailsto______.
Thefollowingscenariowillbeusedforquestions29and30.Johnisanetworkadministratorandhasbeentoldbyoneofhisnet
随机试题
关于渐变流,下述说法中错误的是()。
仲裁与诉讼的根本区别是()
李商隐《锦瑟》:此情可待成追忆,_________。
向日葵、甜菜、高粱和棉花属耐酸性植物。[]
乳痈初期的内服方是
患者,男,50岁。急性胰腺炎住院。医嘱:立即插胃管进行胃肠减压。如果在插管过程中,该患者出现恶心呕吐,护士首先应
中小跨桥梁实体桥墩的墩帽厚度,不应小于()。【2013年真题】
佝偻病的预防原则是:系统管理,综合防治,因地制宜,早防早治。()
宪法的修改,应由全国人民代表大会以全体代表的()
They’ve______thepricesintheshop,soit’sagoodtimetobuy.
最新回复
(
0
)