单项选择题
You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 contains a database that utilizes SQL Server log shipping. Log shipping occurs every 30 minutes. Each night， a full backup is made of the database， and all database indexes are rebuilt. The company’s network administrator reports that SQL1s network utilization becomes excessive after the nightly maintenance tasks are complete. You need to reduce the network bandwidth utilization for SQL1. What should you do？（）
A.Configure the database to use the bulk-logged recovery model.
B.Each night， rebuild only those indexes that require it.
C.Disable log shipping before the nightly maintenance. Re-enable log shipping after nightly maintenance completes.
D.Increase the time between transaction log backups.
相关考题
-
单项选择题
Youareadatabaseadministratorforyourcompany.Eachnight，youperformfullbackupsofyourSQLServer2005computer.Duringbusinesshours，youperformhourlytransactionlogbackups.Yourebuilddatabaseindexeseachnight.Youneedtomodifyyourbackupstrategy.Youmustensurethatthedatabaserecoverstoanewserverasquicklyaspossible.Whatshouldyoudo？（）
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.
