首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. The server contains your company’s order processing database. Two-hundr
You are the administrator of a SQL Server 2000 computer. The server contains your company’s order processing database. Two-hundr
admin
2009-05-19
46
问题
You are the administrator of a SQL Server 2000 computer. The server contains your company’s order processing database. Two-hundred operators take orders by telephone 24 hours a day. Threehundred data entry personnel enter data from orders received by mail.
To ensure that order data will not be lost, your company’s disaster recovery policy requires that backups be written to tape. Copies of these tapes must be stored at an off-site company location. Orders must be entered into the database before they can be filled. If the server fails, you must be able to recover the order data as quickly as possible.
You need to create a backup strategy that meets the company requirements and minimizes server workload. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)
选项
A、Perform a combination of full database and filegroup backups.
B、Perform a combination of full database and file backups.
C、Perform a combination of full database, differential, and transaction log backups.
D、Back up the data to a local tape drive.
E、Back up the data to a network share, and then use enterprise backup software to write the disk backups to tape.
答案
C,E
解析
Explanation:
C: Most OLTP backup schemes include a full database, differential, and transaction log backups
E: In order to recover the data as quickly as possibly we backup the data to network share, and then backup that share to tape. This minimizes the impact of the backup process on the SQL Server computer.
Note 1: SQL Server 2000 provides three database recovery models. These are the Simple recovery model, the Full Recovery Model and the Bulk-Logged Recovery model. Simple Recovery requires the least administration. In the Simple Recovery model, data is recoverable only to the last full database or differential backup. Transaction log backups are not used, and consequently, minimal transaction log space is required.
This Recovery Model is not an appropriate choice for production systems where loss of recent changes is unacceptable. Full Recovery and Bulk-Logged Recovery models provide the greatest protection for data. These models rely on the transaction log to provide full recoverability and to prevent work loss in the broadest range of failure scenarios.
The Full Recovery model provides the most flexibility for recovering databases to an earlier point in time. The Bulk-Logged model provides higher performance and lower log space consumption for certain large-scale operations. It does this at the expense of some flexibility of pointin- time recovery. In this scenario we would want to implement the Full Recovery model as this Recovery model provides complete protection against media failure and provides the ability to recover the database to the point of failure or to a specific point in time.
To guarantee this degree of recoverability, all operations are fully logged. The backup strategy for full recovery consists of database backups, differential backups, which are optional, and transaction log backups. The differential backups are optional but have less of an effect on the system while they run, as they are smaller than full database backups.
This is because a differential backup creates a copy of all the pages in a database modified after the last database backup. A transaction log backup makes a copy only of the log file and backs up the changes made to the database after the last full or differential database backup. A log file backup cannot be used by itself to restore a database. A log file is used after a database restore to recover the database to the point of the original failure. The full database, differential, and transaction log backups can be written to a hard disk or other disk storage media such as a tape drive.
Disk backup devices can be defined on a local disk of a server or on a remote disk on a shared network resource. Tape backup devices are used in the same way as disk devices, with the exception that the tape device must be connected physically to the computer running an instance of SQL Server. SQL Server 2000 thus does not support backing up to remote tape devices.
Note 2, file backup, filegroup backup: SQL Server 2000 supports backing up or restoring individual files or filegroups within a database. This is a complex backup and the restore process that is usually reserved for large databases with high availability requirements. If the time available for backups is not long enough to support backing up the full database, subsets of the database can be backed up at different times. If a disk holding database files or filegroups fails, the site can restore just the lost files or filegroups. This allows for a quicker recovery because only the damaged files or filegroups are restored in the first step, not the entire database.
Incorrect Answers:
A: An OLTP server requires transaction log backups in order to be able to recover up to the point of failure.
B: An OLTP server requires transaction log backups in order to be able to recover up to the point of failure.
D: Backing up to a local tape device would minimize cost but it would compared to a backup to a network it would decrease performance of the server more, and it would take more time to recover.
转载请注明原文地址:https://kaotiyun.com/show/4uhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
About3billionpeoplelivewithin100milesofthesea,anumberthatcoulddoubleinthenextdecadeashumansflocktocoasta
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
YouaredoingyourUCLAapplicationforgraduateadmission,andyouneedtworeferenceletters.Pleaseemailyourformerforeign
DespiteincreasedairportsecuritysinceSeptember11th,2001,thetechnologytoscanbothpassengersandbaggageforweaponsan
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Parentsarenottheonlyonesresponsiblefortheirchildren.Oursocialresponsibilityisatitsgreatestwhenparentsareunab
设置过滤器时,应先选择database菜单中的()选项。A.setupB.browseC.appendD.copyto
Guest账户和Administrator账户一样是由系统建立的,不能被禁用。
随机试题
最容易发生嵌顿的腹外疝是【】
“十八大”报告指出,建设中国特色社会主义,总依据是()
女性,28岁。确诊甲状腺功能亢进症半年,在服甲巯咪唑(他巴唑)治疗过程中突然寒战、发热、咽痛住院。体检:扁桃体肿大,溃烂有黄绿色分泌物,躯干可见坏死性皮疹,肝肋下1cm。化验:WBC1.0×109/L,中性粒细胞0.40,疑诊为粒细胞缺乏症引起的败血症
有下列哪一种情形的属于劣药
根据我国药品管理的法律关系,药品管理法律关系主体之间权利义务指向的主要客体是()。
某市前进无线电厂生产的“红星”牌收录机十分畅销。商标法公布后,无线厂及时进行了注册,获得了该商标的专用权。但是好景不长,1996年8月,该无线厂多次接到顾客投诉,称所购“红星”牌收录机质量低劣,用不了几天就坏了。该厂立即对产品进行质量检验,并未发现质量问题
期货从业机构对违反《期货从业人员执业行为准则》规定的期货业务辅助人员或其它人员进行处理的,应当在( )个工作日内向协会报告。
金融远期合约、金融期货、金融期权、金融互换通常被称作结构化金融衍生工具。( )
设函数f(x)具有二阶导数,g(x)=f(0)(1-x)+f(1)x,则在区间[0,1]上().
ReviewingthedecadethatfollowedWorldWarn,Cartwrightspeaksofthe"excitementandoptimism"ofAmericansocialpsycholo
最新回复
(
0
)