2. 计算机
  3. You are the administrator of SQL Server 2000 computer. The server contains a database named Medical Records. This database conta

You are the administrator of SQL Server 2000 computer. The server contains a database named Medical Records. This database conta

admin2009-05-19  15
问题 You are the administrator of SQL Server 2000 computer. The server contains a database named Medical Records. This database contains clinical records and administrative records. The database consumes about 30GB of disk space. The data files are configured as shown in the exhibit.


You run full database backups each night after business hours. You notice that the backup is not complete by the time the morning shift begins to use the database.

You need to minimize the time needed to restore data in the event of a system, failure. You also want to reconfigure the database to allow the backups to complete during the evening hours.
Which two actions should you take? (Each correct answer represents part of the solution. Choose two)

A. Reorganize the data files into two groups. Place the system tables in the PRIMARY filegroup and the user-defined tables in the other filegroup.

B. Reorganize the data files into three groups. Place the system tables and shared objects in the PRIMARY filegroup, the clinical records in a filegroup, and the administrative records in a filegroup.

C. Reorganize the data files into three groups. Place the system tables in the PRIMARY filegroup, the indexes in a filegroup, and the tables in the other filegroup.

D. Back up the transaction log each night. Run a filegroup backup on a different filegroup each night.

E. Back up the transaction log each night. Run a filegroup backup on the database each weekend.

F. Back up the transaction log each night. Run a differential backup each Sunday, and run a full backup the first day of each month.
选项
答案B,D
解析 Explanation:
B: Split the data into three filegroups: one for system tables and shared object, one for clinical records, and one for administrative records.
The primary filegroup must contain the system tables.

D: By separating the data we can rotate the backup of the filegroups and only backup a single filegroup each night. This will make the backup process quicker and would allow it to complete before business starts in the morning. In order to be able to recover we should also make a log backup every night.

Note: SQL Server 2000 supports backing up or restoring individual files or filegroups within a database, it is possible to reduce backup time by placing data and tables in separate filegroups. Tables, indexes, and text, ntext, and image data can be placed in a specific filegroup. A database can only have one primary filegroup. This filegroup contains the primary data file and any other files not placed in another filegroup. All pages for the system tables are allocated from the primary filegroup. However, a number of user-defined filegroups can be defined for a database. It would thus be possible to reorganize the data files into three groups that can each be backed up separately.

The transaction log holds a record of all modifications that have occurred in the database as well as the transaction that have performed each modification since the transaction log was last backed up. With transaction log backups, it is possible to recover the database to a specific point in time or to the point of failure. They generally use fewer resources than database backups and can thus be backed up more frequently than database backups. This would decrease risk of data loss; however, transaction log backups are used only with the Full and Bulk-Logged Recovery models.

Incorrect Answers:
A: Tables, indexes, and text, ntext, and image data can be placed in specific filegroups. However, the user-defined tables would be much larger than the system tables and might require further partitioning to ensure that the backup of this filegroup is complete.

C: Splitting the indexes and the tables into different filegroups could increase performance for join querires. It would not be a good idea in this scenario however since the separate filegroups are backup up on different days. Therefore a restore operation could give a situation where the indexes and the tables not were up to date. In fact if the indexes of a table span multiple filegroups, all filegroups containing the table and its indexes must be backed up together

E: Running a filegroup backup on the weekend would increase the amount of time between data backups and would increase the time required for recovery as each transaction log backup created since the last filegroup backup would have to be restored in the same sequence in which they were created.

F: Running a differential backup each Sunday, and run a full backup the first day of each month while backing up the transaction log each night would increase the required time for data recovery. In this solution we would have to back up the active transaction log, restore the most recent database backup, restore the most recent differential backup and then restore each transaction log backup created since the last differential backup in the same sequence in which they were created.
转载请注明原文地址:https://kaotiyun.com/show/ruhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

相关试题推荐
随机试题
最新回复(0)