首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
45
问题
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
微软认证
相关试题推荐
Chinaplanstospendbillionsofdollarsinthenextfewyearstodevelopmediaandentertainmentcompaniesthatithopescanco
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
Itishardtomakemoneypeddlingsocialmediaanywhere.Duringtheirfirstfewyearsinbusiness,FacebookandTwitterlostpo
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
Writeanessayof160-200wordsbasedonthefollowingtable.Youressayshould1.describethechangesintheaveragefamilyex
Whethertheeyesare"thewindowsofthesoul"isdebatable;thattheyareintenselyimportantininterpersonalcommunicationis
DrRichardBergland,abrainresearcherattheHarvardMedicalSchool,haswrittenapapersuggestingthathumanbrainisbasica
Writealettertoamuseum’sstafftoaskforsomeinformationaboutahistoricalexhibition.Youshouldincludethedetailsyo
Asthelatestcropofstudentspentheirundergraduateapplicationformandweighuptheiroptions,itmaybeworthconsidering
在用户管理组administrators中删除lusi用户。
随机试题
Inmostcasestheseindividualsaredreamingofwealthandfame,notthelonghoursaloneatatypewriter.
某企业与大学研究所签订协议开发新型材料,双方分别承担相应的任务,最后对研究成果进行集成,双方共享研究成果,这种研发模式属于()。
有些人的心情比较容易受到外界影响。比如飞行员担心遇到雷暴,虽然没有什么奇招,但有些食物的确能让大脑更好地运作,可可就是其中之一。这是因为可可含有大量的茶碱和咖啡因。它们可以有效地减轻压力和缓解疼痛。以下哪项如果为真,最能支持上述观点:
关于粪便常规检查,留取标本的正确要求是
下列各项中,属于破产程序终结的情形有:()
下面关于价值工程的论述中正确的是:
周先生夫妇毕业于同一所大学,有一个读小学一年级的7岁女儿。丈夫在外资企业做行政管理工作,月薪税后4260元,年终奖金2万元;妻子是某事业单位财务主管,每月税后工资3150元,年终奖金有5000元。家庭财务支出比较稳定,基本的伙食费、交通费、通讯费大概每月3
旅行社不再从事旅游业务的,凭旅游行政管理部门出具的凭证,向银行取回质量保证金。()
[*]
"Iwouldtellanyonewho’sthinkingaboutgoingbacktoschoolthatit’snotasdifficultasyouthink,"saysKarenJonaitis,a
最新回复
(
0
)