首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
58
问题
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
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
Writeane-mailofabout100wordstoaforeignteacherinyourcollege,invitinghim/hertobeajudgefortheupcomingEnglish
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
Whethertheeyesare"thewindowsofthesoul"isdebatable;thattheyareintenselyimportantininterpersonalcommunicationis
TheU.S.PostalService(USPS)continuestobleedredink.Itreportedanetlossof$5.6billionforfiscal2016,the10thst
Google,whichdominatesmuchoflifeontheInternet,hasbeentryingtoexpandbeyondcomputersandtelephonestolivingrooms,
在用户管理组administrators中删除lusi用户。
Exhibit:BULKINSERTEzonexam.dbo.employeesFROM‘tk\africe\fubar512.txt’WITHDATAFILETYPE=‘char’,FIELD/TERMINATOR=‘\t’,R
随机试题
男性,28岁,转移性右下腹痛6h,确诊为阑尾炎穿孔,拟在硬膜外阻滞麻醉下行阑尾切除术。为该病人做硬膜外阻滞麻醉,准备工作不包括以下哪项
患者,女,56岁。因慢性胆囊炎急性发作入院治疗,给予抗感染、补液、对症治疗,日输液量1000ml。今晨输液过程中,突然出现胸闷、胸骨后疼痛,继之呼吸困难、严重发绀,主诉有濒死感觉,听诊心前区可闻及一个响亮、持续的“水泡声”。此时患者应采取的体位是
游泳馆、公共浴室的顶棚面应设较大坡度,其主要原因是?[2007—094]
在常规设备条件下,全断面一次掘进硐室的高度,一般不得超过()m。
下列行为属于公平竞争的是()。
甲公司2012年12月份A商品有关收、发、存情况如下:(1)12月1日结存300件,单位成本为2万元。(2)12月8日购入200件,单位成本为2.2万元。(3)12月10日发出400件。(4)l2月20日购入300件,单位成本为2.3万元。(5)12月28
下列情形中,侵犯了公民宪法权利的是:
“横眉冷对千夫指,俯首甘为孺子牛”这句话说明了人格具有()特征。
下列关于多元文化基本理念的叙述,正确的是()。
A、Peopleenjoyshoppinginthem.B、Peoplespendlittletimeinthem.C、Peoplearemorelikelytobuysomethinginthemiftimei
最新回复
(
0
)