违法和不良信息举报 联系客服
免费注册 登录

You are the administrator of a SQL Server 2000 computer. You have two new hard disks on which you will create a database named inventory. You want to insert, update, and delete data as quickly as possible.Which two actions should you take? (Each correct a

题目

You are the administrator of a SQL Server 2000 computer. You have two new hard disks on which you will create a database named inventory. You want to insert, update, and delete data as quickly as possible.

Which two actions should you take? (Each correct answer presents parts of the solution. Choose two)

A. Configure the hard disks as two mirrored NTFS volumes.

B. Configure the hard disks as one mirrored NTFS volumes.

C. Configure the hard disks as two independent NTFS volumes.

D. Configure the hard disks as one extended NTFS volume.

E. Place inventory_data.mdf on the first volume and inventory_log.ldf on the second volume.

F. Place inventory_data.mdf on the first volume and inventory_data2.ndf and inventory_log.ldf on the second volume.

G. Place inventory_data.mdf and inventory_log.ldf on the same volume.

参考答案和解析
正确答案：CE
C,E 解析：Explanation: Placing log files and the data files on different physical disks or independent volumes, and placing the log file of a drive that does not hold the operating system can improve database performance as it allows the frequently written to log file to exist a disk with its own read/write heads and thus less seek time.

Note: A Windows 2000 supports basic disks, in which physical disks are divided into partitions, and dynamic disks, in which disks are divided into volumes that can comprise an entire disk, two or more entire disks, portions of a disk, or portions of up to 32 physical disks.

A NTFS volume is volume that is formatted with the NTFS file system. Physical database design involves mapping the logical design onto physical media to allow for the data to be physically accessed and maintained as quickly as possible by taking advantage of the available hardware and software features. It is important to correctly design the database and to take advantage of hardware and software features early in the development cycle of a database application, because making changes to these components at a later stage it is difficult.

Incorrect Answers:
A: For redundancy and fault protection the log file can be placed on a mirrored volume. It would not be a good idea to put data files on a mirrored volume though. Performance when accessing the data would suffer.

Note: A mirrored volume is a fault-tolerant volume that duplicates data on two physical disks. It provides data redundancy as it copies the data on one volume to another volume on a different disk. When one of the physical disks fails, the data on the failed disk becomes unavailable, but the system can continue to operate by using the mirror disk. In such a set up, the data file and the log file will reside on the same drive. This will not improve database performance.

B: A mirrored volume cannot comprise of one volume only. It must comprise of two volumes on separate physical disks as a mirrored volume is a fault-tolerant volume that duplicates data on two physical disks. When one of the physical disks fails, the data on the failed disk becomes unavailable, but the system can continue to operate by using the mirror disk.

D: Data is written and read sequentially on extended volumes. As a result the data file and the log file will be placed on the same physical disk.

F: In this scenario the data file is separated into a primary data file, that uses the .mdf extension, and a secondary data file, that uses the .ndf extension. However, the secondary data file is placed on the same volume as the log file. This will lead to performance improvements only in cases where data is not read from the secondary data file.

G: Placing the data file and the log file on the same volume will not improve database performance as it will not allow parallel processing.
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.

Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.

What should you do?

A．Enable the torn page detection database option for each database.

B．Disable write caching on all disk controllers.

C．Ensure that write caching disk controllers have battery backups.

D．Create a database maintenance plan to check database integrity and make repairs each night.


正确答案：C
解析：Explanation:Thescenariostatesthatpowerinterruptionshaveoccurredinthepast.Bybuyingabatterybackupsolutionforthediskcontrollersthepowerinterruptionproblemwouldbeprevented.IncorrectAnswers:A:Tornpagedetectionisareactivesolutionwhichwouldslowdownperformancesincerestoreswouldhavetobemade.Itwouldbettertouseapreventivesolution.Note:Tornpagedetection:Ifatornpageisdetected,thedatabasemustberestoredfrombackupbecauseitwillbephysicallyinconsistent.B:Cachingisveryimportforperformance.Disablingwrite-cachingwouldbeabadidea.D:Repairingthedatabaseeverynightisnotagoodsolution.Databaseerrorscannotbeaccepted.Itisbettertopreventtheprobleminsteadoftryingtofixitafterithashappened.

第2题：

You are the administrator of three SQL Server 2000 computers at Five Lakes Publishing. One server, FLPSQL01, stores order data. You want to be able to use the other two servers, FLPSQL02 and FLPSQL03, to answer queries and run report. The planned network configuration is shown in the exhibit.

You want to use the database Maintenance Plan wizard to configure log shipping from FLPSQL01 to FLPSQL02 and FLPSQL03. You do not want users to add any new data on FLPSQL02 and FLPSQL03, but they must be able to run queries and reports.

Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

A．Set the database load state for each destination server to No recovery mode.

B．Set the database load state for each destination server to standby mode.

C．Enable the allow database to assume primary role option for both destination servers.

D．Enable the allow database to assume primary role option for one destination server and then disable this option for other destination server.

E．Disable the allow database to assume primary role option for both destination servers.


正确答案：BE
解析：Explanation:B:Astandbyservercanbemaintainedtotaketheplaceoftheprimaryproductionserver,ifneeded.AstandbyserverisasecondarySQLServerinstallationthatiskeptup-to-datewithaprimarySQLServerinstallationthroughtheapplicationoftransactionlogbackupfiles.Youcanautomatetheprocessofmaintainingastandbyserverbycreatingbackup,copy,andrestorejobsthatareperiodicallyexecutedbySQLServerAgentontheprimaryserverandonthestandbyserver.Thisautomatedprocessiscalledlogshipping.Ifyouwantthedestinationdatabasetobeviewableforread-onlyqueries,youmustselecttheStandbyModeoption,thedefaultistheNoRecoveryModeoption.TheStandbymodespecifiesthatthesecondarydatabasebemadeavailableforuse,butinread-onlymode.E:Wedon'twantuserstoaddanydataonFLPSQL02orFLPSQL03.Thereforeweshoulddisabletheallowdatabasetoassumeprimaryroleoptionforthem.IfthisoptionwereenabledFLPSQL02andFLPSQL03wouldbeabletobeusedassourceservers.IncorrectAnswers:A:Thenorecoverymodespecifiesthatthesecondarydatabasebemadeunavailableforuse.WeneedstandbymodesincewewantFLPSQL02andFLPSQL03usedforqueriesandreports.Note:TheactiveportionofthetransactionlogontheprimaryservercanbebackedupusingtheNORECOVERYbackupoption.Thisoptionleavestheprimarydatabaseinrecoverymode.Whentheprimaryserverisreadytobebroughtbackonline,thetransactionlogsfromthestandbyserver(fortheperiodthatuserswereusingthestandbyserverastheprimaryserver)canbeappliedtotheprimaryserver.Thisavoidsthenecessityofapplyingacompletedatabasebackupandallapplicabletransactionlogstorestoretheprimaryserver.Theresultisasignificantdecreaseinthetimerequiredtobringtheprimaryserverbackonline.C:Theprimaryroleoptionmustbedisabledforbothdestinationservers.Ifnottheywouldbeabletochangeandupdatedata.D:Theprimaryroleoptionmustbedisabledforbothdestinationservers.Ifnottheywouldbeabletochangeandupdatedata.

第3题：

You are a network administrator for your company. You manage a computer named Server6 that runs Windows Server 2003 with the default settings.You install Terminal Services on Server6. You attempt to connect to Server6 by using the URLhttp://Server6/Tsweb. You cannot connect to Server6. You need to be able to access Terminal Services on Server6 by using Internet Explorer 6.0.Which two actions should you perform? （）(Each correct answer presents part of the solution. Choose two.)

A. Create a new Web site named Tsweb.

B. Create a new virtual directory named Tsweb.

C. Install IIS.

D. Install the Remote Administration IIS subcomponent.

E. Install the Remote Desktop Web Connection IIS subcomponent.


参考答案：C, E

第4题：

You are the administrator of a SQL Server 2000 computer. Your company purchased an accounting application from a vendor. The application stores its data in a database named Accounting on the server. The tables in this database contain columns that function as primary keys, but PRIMARY KEY and FOREIGN KEY constraints are not used.

You need to replicate data from this database to another SQL Server computer. This server will use the replicated data to generate reports. Most reports will run each month, but the accounting department needs to have the ability to run reports at any time. Reports should be accurate through the last full working day.

You cannot make any changes to the database, but you need to implement replication. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

A．Implement merge replication.

B．Implement snapshot replication.

C．Implement transactional replication.

D．Schedule replication to run continuously.

E．Schedule replication to run during off-peak hours.


正确答案：BE
解析：Explanation:
B: Snapshot replication is the best solution since we will not be making changes to the Accounting database but need to replicate data from the database to another SQL Server computer and as the accounting department needs to have the ability to run reports that only need to be accurate through the last full working day.

E: Only one snap-shot replication would be necessary per day, and to make as little impact on the daily use of the server this replication should be scheduled during off-peak hours.

Note: SQL Server 2000 provides three types of replication that can be used in distributed applications. These are snapshot replication, transactional replication and merge replication. Each type provides different capabilities.

Snapshot replication is the process of copying and distributing data and database objects exactly as they were at the time the snapshot was taken. Snapshot replication does not require continuous monitoring of changes because changes made to published data are not propagated to the Subscriber incrementally. Subscribers are updated with a complete data set and not individual transactions. As snapshot replication replicates an entire data set at one time, it may take longer to propagate data modifications to Subscribers. This type of replication in helpful in situations when data is mostly static and does not change often; it is acceptable to have copies of data that are out of date for a period of time; replicating small volumes of data; and when sites are often disconnected and high latency (the amount of time between when data is updated at one site and when it is updated at another) is acceptable.

In transactional replication, an initial snapshot of data is propagated to Subscribers, and then when data modifications are made at the Publisher, the individual transactions are captured and propagated to Subscribers. SQL Server 2000 monitors INSERT, UPDATE, and DELETE statements, and changes to stored procedure executions and indexed views. SQL Server 2000 stores the transactions affecting replicated objects and then it propagates those changes to Subscribers continuously or at scheduled intervals. Transaction boundaries are preserved. Transactional replication is used when data modifications must be propagated to Subscribers, often as they occur; transactions must be atomic; subscribers are mostly connected to the Publisher and when the application will not tolerate high latency for Subscribers receiving changes.

Merge replication allows various sites to work autonomously and merge data modifications made at multiple sites into a single, uniform. result at a later time. The initial snapshot is applied to Subscribers and then SQL Server 2000 tracks changes to published data at the Publisher and at the Subscribers. The data is synchronized between servers either at a scheduled time or on demand. Updates are made independently at more than one server, so the same data may have been updated by the Publisher or by more than one Subscriber. Therefore, conflicts can occur when data modifications are merged. This type of replication is helpful when multiple Subscribers need to update data at various times and propagate those changes to the Publisher and to other Subscribers; Subscribers need to receive data, make changes offline, and synchronize changes later with the Publisher and other Subscribers; the application latency requirement is either high or low, and when site autonomy is critical.

Incorrect Answers:
A: No data at the second server will not be changed so there is no need to use merge replication.

C: We don’t need the accuracy of transactional replication. In this scenario high latency is permissible as the reports must be accurate only through the last full working day.

Note: Transactional replication is used when data modifications must be propagated to Subscribers, often as they occur; transactions must be atomic; subscribers are mostly connected to the Publisher and when the application will not tolerate high latency for Subscribers receiving changes.

D: As the reports must be accurate through the last full working day, it not necessary to run replication continuously. Running replication continuously will place locks on the destination database, which would hamper the performance of queries and actions run against the destination database.

第5题：

You are the administrator of a SQL Server 2000 computer. You want to set up snapshot replication on the server. The server will serve as Publisher and Distributor for a minimum of 40 Subscribers.

Currently, you want to publish 3GB of data, but the data is expected to grow over time. Subscribers will receive a new snapshot each month.

You want to minimize the workload on the Publisher/Distributor. Which two actions should you take to configure snapshot replication? (Each correct answer presents part of the solution. Choose two)

A．Store the snapshot in the default folder on the Publisher/Distributor.

B．Store the snapshot in an alternative folder on the Publisher/Distributor.

C．Store the snapshot in a shared folder on a file server.

D．Create pull subscriptions.

E．Create push subscriptions.


正确答案：CD
解析：Explanation:
C: In SQL Server 2000 it is possible to store snapshot files in a location other than or in addition to the default location. Alternate locations can be on another server, on a network share, or on removable media. Saving snapshot files in an alternate location can alleviate disk overhead on the Distributor.

However, Subscribers running earlier versions of SQL Server cannot use the alternate snapshot location. When specifying the snapshot location on a network share, it is recommended that that share folder be dedicated for snapshot storage and files. Subscribers that need to access the snapshot files will need Read permission to the snapshot location and appropriate folders. If the snapshot folder is not shared for the appropriate Subscribers, the replication agents cannot access the folder and the replication will fail.

D: With pull subscriptions the Subscriber requests data and updates that are made at the Publisher. Thus allows the user at the Subscriber to determine when the data changes are synchronized. With pull subscriptions the administration of the subscription takes place at the Subscriber.

A feature of pull subscriptions is that the Distribution Agent for snapshot and transactional publications and the Merge Agent for merge publications all run at the Subscriber. This can result in a reduction of the amount of processing overhead on the Distributor. However, if needed, the Distribution Agent or Merge Agent can be run at the Distributor to offload agent processing from the Subscriber.

Incorrect Answers:
A: The default location for snapshot replication files are specified in the Specify Snapshot Folder dialog box that appears in the Configure Publishing and Distribution Wizard and in the Create Publication Wizard. The default location is usually on the Distributor.

B: In SQL Server 2000 it is possible to store snapshot files in a location other than or in addition to the default location. Alternate locations can be on another server, on a network share, or on removable media. Saving snapshot files in an alternate location can alleviate disk overhead on the Distributor, particularly when it is located on another server, or a file server.

E: Push subscriptions are created at the Publisher. This places higher processor overhead at a Publisher using a local Distributor as the Distribution Agent for the snapshot publication runs at the Distributor.

第6题：

You are the administrator of two Microsoft Windows 2000 computers. One computer is running Internet Information Services (IIS), and the other is running SQL Server 2000. Company partners need to connect by means of the Internet and query data stored on the SQL Server computer. Some of these partners have computers that do not use Microsoft operating systems or Web browsers.

You need to configure the IIS and SQL Server 2000 computers to allow access to data by means of the IIS virtual directory. IIS uses Basic Authentication to allow access to the virtual directory.

Only company partners should have access to the SQL Server computer by means of the Internet. The partners should not be allowed to make ad hoc queries. You want to be able to audit successful and failed logins to the SQL Server computer.

You want to allow the partners access to the SQL Server computer while keeping your security scheme as simple as possible. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)

A．Configure the IIS virtual directory to allow URL queries.

B．Configure the IIS virtual directory to allow template queries.

C．Create a new Windows user account. Create a corresponding Windows Authenticated login on the SQL Server computer. Configure the IIS virtual directory to always use this login when connecting to the SQL Server computer.

D．Create a Windows Authenticated login on the SQL Server computer for the IIS Internet Guest Account. Configure the IIS virtual directory to always use the Internet Guest Account when connecting to the SQL Server computer.

E．Create a Windows Authenticated login for each company partner on the SQL Server computer. Configure the IIS virtual directory to use Windows Integrated Authentication when connecting to the SQL Server computer.


正确答案：BE
解析：Explanation:B:TheAllowTemplateQueriesoptionletsyoucreateXMLtemplatesthatcontainSQLstatements,whichcanbeusedtoreturndataasXML.Nobrowserwouldberequired,thoughyoucouldcertainlyuseone.Apossiblenon-browserclientcouldbeaVisualBasicapplicationforexample.E:IfyouforcetheuserstoauthenticatethemselvesviaBasicauthentication,IIShasallinformationrequiredtomakethetrustedconnectiontoSQLServer.WesetupIIStouseWindowsIntegratedAuthenticationwhenconnectingtotheSQLServer.WindowsAuthenticationloginsmustbecreatedontheSQLServeraswell.Incorrectanswers:A:URLqueriesallowexecutionofSQLqueriesdirectlyintheURL.Thiswouldrequireabrowserhowever,butnotallpartnersusebrowsers.Note:TheAllowURLQueriesoptionletsyoutypeSelectstatementsdirectlyinthebrowserandreturnthedataasXML.C:TheInternetGuestAccount,notaspecificWindowsaccount,shouldbeusedtoconnecttotheSQLServerfromtheIISserver.D:WeshouldnotallowaccesstotheSQLServerfortheIISInternetGuestaccount.ThatwouldallowallpeopleconnectingtotheIISserveraccesstotheSQLServeraswell.

第7题：

You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company.

The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.

How should you configure the database?

A．Configure the database on the two servers as a SQL Server 2000 cluster.

B．Configure the database on one server, and then configure a standby database on the second server.

C．Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.

D．Configure the database as a federated database, and then partition half the data on each server.


正确答案：A
解析：Explanation: SQL Server 2000 failover clustering provides high availability support by allowing us to configure one failover cluster to automatically, with no manual configuration, fail over to any other node in the failover cluster configuration. In this way, we minimize system downtime and provide high server availability during an operating system failure or a planned upgrade. Before SQL Server 2000 failover clustering can be set up, we must install Windows NT 4.0, Enterprise Edition, Windows 2000 Advanced Server or Windows 2000 Datacenter Server, and the Microsoft Cluster Service (MSCS).

In this scenario a cluster would be preferred to a standby server because it would be available immediately. A standby server on the other would require manual configuration and more time to become online.

Incorrect Answers:
B: A standby server would require you to reconfigure clients to allow it to connect to the standby server when the main server goes down. It would require at least several minutes of manual administration before the standby server would be operational. But the scenario requires that no reconfiguration of the client computers should be necessary. Therefore we should use a SQL Server 2000 cluster not a standby server.

Note: A standby server is a second server that contains a copy of the databases on the primary server and that can be brought online in the event of a primary server failure or due to scheduled maintenance on the primary server. This allows users to continue working with databases when the primary server becomes unavailable. When the primary server becomes available again, any changes to the standby server's copies of databases must be restored back to the primary server.

C: The Microsoft Distributed Transaction Coordinator coordinates distributed transactions, but would not increase availability.

Note: The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the distributed transaction across all the servers enlisted in the transaction.

An installation of SQL Server 2000 can participate in a distributed transaction by calling stored procedures on remote servers running SQL Server, automatically or explicitly promoting the local transaction to a distributed transaction and enlist remote servers in the transaction, and making distributed updates that update data on multiple OLE DB data sources. If these OLE DB data sources support the OLE DB distributed transaction interface, SQL Server 2000 can also enlist them in the distributed transaction. The MS DTC service coordinates the proper completion of the distributed transaction to ensure that either all of the updates on all the servers are made permanent, or, in the case of errors, all erased.

D: With Federated SQL Server 2000 servers, SQL Server 2000 databases can be spread across a group of autonomous database servers. These are capable of supporting the processing growth requirements of the largest Web sites and enterprise data-processing systems built with Microsoft Windows DNA, which divides the processing units of a data processing system into logical tiers. This however does not improve availability.

第8题：

You are the administrator of a SQL Server 2000 database. You import a table of geographic information from a Microsoft access database into a SQL Server 2000 database. The table has 12,000 rows. Each row averages 5,000 bytes. The table contains lockup data that does not change.

You want to minimize the size of the data file and the time required to back up the data. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

A. Create a 60-MB data file named geography.ndf

B. Create a 95-MB data file named geography.ndf

C. Create a 60-MB data file named geography.mdf

D. Create a 95-MB data file named geography.mdf

E. Place the table in the PRIMARY filegroup.

F. Place the table in a new filegroup named LOCATION.


正确答案：BF
B,F 解析：Explanation: As SQL Server 2000 supports backing up or restoring individual files or file groups within a database, it is possible to reduce back up time by creating a separate data file table so that only that table will be backed up. This separate data file will have to be a secondary data file because a database can only have one primary data file, which is identified by the .mdf extension, it is the starting point of the database and locates all the other files in the database. Secondary data files are identified by the .ndf extension and comprise all of the data files except the primary data file. A database need not have a secondary data file and it is also possible to create multiple secondary data files on database.

Rows are stored in data pages. Rows cannot cross different data pages. The size of data page in SQL Server 2000 (or SQL 7.0) is 8,192 bytes. We can only store one row in every data page in this scenario. Thus, to estimate the size of the tale we would need to multiply the number of rows, 12,000 in this scenario, by 8,192 bytes. This will give us a table size of 98,304,000 bytes. As computer data storage is calculated using the binary rather than the decimal system, there is 1,024 bytes per Kb and 1,024 Kb per MB, rather than 1,000 bytes per Kb and 1,000 Kb per MB, we thus require a database size of at least 93.75 MB.

Incorrect Answers:
A: The data size of this table is insufficient as a minimum size of 93.75 MB is required.

C: The data size of this table is insufficient as a minimum size of 93.75 MB is required. Furthermore, the .mdf file extension indicate in this solution implies that the data file will be placed in the primary filegroup. It would thus not be possible to backup the data file pertaining to the table only.

D: The .mdf file extension indicate in this solution implies that the data file will be placed in the primary filegroup. It would thus not be possible to backup the data file pertaining to the table only.

E: As SQL Server 2000 supports backing up or restoring individual files or file groups within a database, it is possible to reduce back up time by creating a separate data file table so that only that table will be backed up. This separate data file will have to be a secondary data file because a database can only have one primary data file, which is identified by the .mdf extension, it is the starting point of the database and locates all the other files in the database.

第9题：

You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.

You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.

You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?

A．Increase the maximum file size of Sales_Data to 1,500MB.

B．Use the DBCC SHRINKDATABASE statement.

C．Set automatic file growth to 10 percent.

D．Create another data file named Sales_Data2 in a new SECONDARY filegroup.


正确答案：A
解析：Explanation: By examining the first exhibit we see that the database has reached its maximum size of 1001 MB. The data file is located on drive E and the second exhibit shows us that there is enough free space on that disk to increase the maximum size of the data file to 1,500 MB.

Incorrect Answers:
B: DBCC SHRINKDATABASE could possibly shrink the database and new records could be added for a while, but it would just be a temporary solution.

C: The database is already set to automatic file growth, but it has reached the maximum size.

D: The primary file has reached it maximum size. A secondary filegroup would help if it was set to the default file group. New data would still be added to the primary filegroup which is at its maximum size.

第10题：

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.


正确答案：CE
解析：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.

更多相关问题
相关内容