首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
57
问题
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
微软认证
相关试题推荐
CigarettesmokingisahealthhazardofsufficientimportanceintheUnitedStatestowarrantappropriateremedialaction.Itwa
Fewthingssay"forgetI’mhere"quitesoeloquentlyastheposeoftheshy—theavertedgaze,thehunchedshoulders,thebodypi
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
"Thisisareallyexcitingtime—aneweraisstarting,"saysPeterBazalgette,thechiefcreativeofficerofEndemol,thetelev
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
Google,whichdominatesmuchoflifeontheInternet,hasbeentryingtoexpandbeyondcomputersandtelephonestolivingrooms,
Youaretheadministratorofyourcompany’snetwork.Thenetworkisconfiguredasshownintheexhibit.YouwanttoinstallW
随机试题
在学校,体现国家意志的课程是()。
在PowerPoint2003中,如果要改变幻灯片的大小和方向,可以选择______命令。
A.小茴香B.木香C.两者都选D.两者都不选天台乌药散的药物组成中有
患者女,初产妇。宫内妊娠37周,胎膜早破超过3天,原发性宫缩乏力,宫口扩张缓慢,体温连续两次38℃以上,宫缩间歇宫底压痛明显,疑有宫内感染,拟行剖宫产术。适宜的剖宫产手术方式是
某男,37岁,咳嗽痰多,胸闷气急,证属痰气阻肺,宜选用()。
项目施工安全管理中,()对本工程项目的安全生产负全面领导责任。
下列各项中,属于会计职业道德的外在教育的是()。
司马迁心胸开阔,不带成见,是个严格的史学家,而不是儒教的提倡者,在议题上他采取________的态度。他极度崇敬孔子,但他不是个________的孔门信徒。他所描绘的孔子是个人,而不是个圣人。填入画横线部分最恰当的一项是:
下列关于信息认证的叙述中,不正确的是______。
如果将窗体背景图片存储到数据库文件中,则在“图片类型”属性框中应指定______方式。
最新回复
(
0
)