首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. The server contains a database that stores inventory data. Another data
You are the administrator of a SQL Server 2000 computer. The server contains a database that stores inventory data. Another data
admin
2009-05-19
49
问题
You are the administrator of a SQL Server 2000 computer. The server contains a database that stores inventory data. Another database administrator has created a number of scheduled jobs to maintain the inventory database. Each weeknight the following jobs occur.
-- A BULK INSERT job imports data at 10:00 P.M.
-- Indexes are rebuilt at 10:15 P.M.
-- Data integrity checks are performed at 10:30 P.M.
-- A differential backup is performed at 10:45 P.M.
-- A DBCC SHRINKDATABASE job runs at 11:00 P.M.
You notice that the final job often fails and returns the following error message: "Server Msg 3140, Level 16, State 3. Could not adjust the space allocation for file ’inventory_data’."
You need to ensure that the final job runs without errors. What should you do?
选项
A、Create a new DBCC SHRINKFILE job to shrink the inventory_data file. Schedule the new job to run at the same time as the DBCC SHRINKDATABASE job.
B、Modify the DBCC SHRINKDATABASE job so that it uses DBCC SHRINKFILE statement to shrink each file individually.
C、Increase the time between the data integrity checks and the differential backup.
D、Increase the time between the differential backup and the DBCC SHRINKDATABASE job.
答案
D
解析
Explanation: The DBCC SHRINKDATABSE cannot be executed until the previous job step, the differential backup, has been completed. We should increase the time between these two job steps, or even better configure the last job step to run only after the differential backup has been completed.
Note: The DBCC SHRINKDATABASE statement shrinks data files on a per-file basis but shrinks log files as if all the log files existed in one contiguous log pool. The target size for the data and log files cannot be smaller than the minimum size of a file that was specified when the file was originally created, or the last explicit size set with a file size changing operation such as the ALTER DATABASE statement with the MODIFY FILE option or the DBCC SHRINKFILE statement.
Incorrect Answers:
A: The DBCC SHRINKDATABASE command shrinks the whole database. Shrinking a single data file would not be the optimal solution to shrink the database.
Note: The DBCC SHRINKFILE statement shrinks the size of the specified data or log file in the related database and is used to reduce the size of a file to smaller than its originally created size. The minimum file size for the file is then reset to the newly specified size.
By using the EMPTYFILE argument in conjunction with the DBCC SHRINKFILE statement before executing the ALTER DATABASE statements, we can remove the data in a file. Other users can be working in the database when the file is shrunk, thus the database being shrunk does not have to be in single-user mode when using the DBCC SHRINKFILE statement.
The DBCC SHRINKDATABASE statement shrinks data files on a per-file basis but shrinks log files as if all the log files existed in one contiguous log pool. The target size for the data and log files cannot be smaller than the minimum size of a file that was specified when the file was originally created, or the last explicit size set with a file size changing operation such as the ALTER DATABASE statement with the MODIFY FILE option or the DBCC SHRINKFILE statement. These two functions thus adjust the space allocation on a per-file basis and cannot run at the same time.
B: The DBCC SHRINKDATABASE statement shrinks data files on a per-file basis already. There is no need to use the DBCC SHRINKFILE statement to shrink each file individually.
Note: The DBCC SHRINKDATABASE statement shrinks log files as if all the log files existed in one contiguous log pool. The target size for the data and log files cannot be smaller than the minimum size of a file that was specified when the file was originally created, or the last explicit size set with a file size changing operation such as the ALTER DATABASE statement with the MODIFY FILE option or the DBCC SHRINKFILE statement.
C: Database integrity checks such as the DBCC CHECHDB statement should be run before any major system changes, such as a hardware or software upgrade, or after a hardware failure, or if a system problem is suspected. It is not necessary to run database integrity checks as part of the normal backup or maintenance procedures.
转载请注明原文地址:https://kaotiyun.com/show/LuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
In2009theEuropeanCommissioncarriedoutaninvestigationintoMicrosoft.TheAmericansoftwaregianttiedInternetExplorer,
In2009theEuropeanCommissioncarriedoutaninvestigationintoMicrosoft.TheAmericansoftwaregianttiedInternetExplorer,
In2009theEuropeanCommissioncarriedoutaninvestigationintoMicrosoft.TheAmericansoftwaregianttiedInternetExplorer,
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
Thisweekandnext,governments,internationalagenciesandnongovernmentalorganizationsaregatheringinMexicoCityattheWo
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
随机试题
关于建筑装饰装修工程的造价计算区别于一般房屋建筑工程造价计算,以下说法中正确的有()。
财政政策可分为紧缩性的财政政策与扩张性的财政政策,与证券市场的关系十分密切,如果一国实行扩大财政支出,加大财政赤字的政策,则股票价格会出现( )。
证券交易所的设立和解散由()决定。
某县城一家房地产开发企业2015年度受让一宗土地使用权,支付土地使用权价款1000万元并缴纳契税,取得契税完税凭证。1月,将其中80%的面积用于开发建造住宅楼,当年建成后,将80%的建筑面积直接对外销售,取得销售收入7500万元;其余部分对外出租,本年度内
乙股份有限公司(以下简称乙公司)为华东地区的一家上市公司,属于增值税一般纳税人,乙公司2014年至2017年与固定资产有关的业务资料如下:(1)2014年12月1日,乙公司购入一条需要安装的生产线,取得的增值税专用发票上注明的生产线价款为1170万元
“孟母三迁”的故事说明()对人的身心发展的影响。
《共产党宣言》
[*]
考生文件夹下有一个数据库文件“samp3.accdb”,其中存在已经设计好的表对象“tEmployee”和宏对象“m1”,同时还有以“tEmployee”为数据源的窗体对象“fEmployee”。清在此基础上按照以下要求补充窗体设计。单击命令按钮bLi
FormanypeopleintheU.S.,sportsarenotjustforfun.Theyarealmostareligion.Thousandsofsportsfansbuyexpensivetic
最新回复
(
0
)