单项选择题
You are a database administrator for your company. Each night， you perform full backups of your SQL Server 2005 computer. During business hours， you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your backup strategy. You must ensure that the database recovers to a new server as quickly as possible. What should you do？（）
A.Schedule the full backups to run after the nightly index is rebuilt.
B.Schedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.
C.Schedule an additional transaction log backup to run after the nightly index is rebuilt.
D.Schedule a marker to be added to the transaction log before the nightly index is rebuilt.
相关考题
-
单项选择题
Youareadatabaseadministratorforyourcompany.Adatabaseononeofthecompany’sSQLServer2005computersstorestransactioninformationforthecompany’sWeb-basedordersystem.Thedatabaseisconfiguredtousethefullrecoverymodel.Yourcompanyreceivesveryfewordersbetweenthehoursof19：00and04：00.Yourmaximumacceptableriskfordatalossisonehour.Databasebackupsmustbeperformedasquicklyaspossible.Youneedtodevelopamaintenanceplantomanagethisrisk.Whatshouldyoudo？（）
A.Configure a Back Up Database task to do a full backup of the database every hour.Configure a Check Database Integrity task to run every hour.
B.Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a third Back Up Database task to do transaction log backups every hour.
C.Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a Check Database Integrity task to run every hour.
D.Configure a Back Up Database task to do a full backup at 09：00 and 14：00.Configure a second Back Up Database task to do transaction log backups every hour. -
单项选择题
YouareadatabaseadministratoroftwoSQLServer2005computersnamedSQL1andSQL2.YouhaveaMicrosoft.NETapplicationthathasbeenmodifiedsothatitnowaccessesadatabaseonSQL2inadditiontoSQL1.YoudonotwanttheuserapplicationtoconnectdirectlytoSQL2.YouneedtoenablethedataretrievalfromSQL2whilemaintainingtheabilitytoassigndifferentpermissionstodifferentuserswhousethe.NETapplication.Whatshouldyoudo？（）
A.Change the .NET application to define a new server connection to SQL2.
B.Configure a linked server on SQL1 to point to SQL2.
C.Configure a linked server on SQL2 to point to SQL1.
D.Change the stored procedures called by the .NET application to include the OPENXML command. -
单项选择题
Youareadatabaseadministratorforyourcompany.ThecompanyusesaSQLServer2005database.Afullbackupofthedatabaseismadeeachnight.Transactionlogbackupsaremadeeachmorningandeachafternoon.Younoticethatthedatabasetransactionlogfilegrowsverylargethroughouttheday.Youneedtominimizethesizeofthetransactionlogfile.Youalsoneedtominimizedatalossintheeventofafailure.Whatshouldyoudo？（）
A.Decrease the amount of time between transaction log backups.
B.Configure the database to use the simple recovery model.
C.Configure the RECOVERY INTERVAL option to be a smaller value.
D.Run DBCC SHRINKFILE on the transaction log file.
