SMS 2003 Certification Question - Day Twenty
Test questions sponsored by Actualtests.com
SMS Expert and myITforum.com
Don’t forget to stop by our
forum, it’s open for discussion!
You are the SMS administrator for myITforum.com. The SMS 2003 site hierarchy consists of a
single primary site running SMS 2003 SP1. You are responsible for implementing a backup and recover strategy for the SMS site.
You are required to verify the integrity of the SMS site database. You want to run a SQL Server DBCC test to
verify that there are no integrity problems with the SMS site database immediately after the backup operation is
completed.
What should you do to achieve the desired goal by involving minimum administrative effort?
A. Configure the SMSbkup.ctl file to run the SQL Server DBCC test.
B. Run the SQL Server DBCC test immediately after the backup operation is completed.
C. Create a batch file that runs the SQL Server DBCC test at the end of the backup operation and save the
batch file as AfterBackup.bat in the SMS\inboxes\Smsbkup.box folder.
D. Create a script that runs SQL Server DBCC test immediately after the backup operation is completed.
E. Detach the database and make a backup in SQL Enterprise Manager.
Remember no need to submit your answer until Tuesday but you can if you like.
Please email me your answer and try to include the answer in the subject line please.
06:38 - Sep 02, 2006
Trackbacks
No Trackbacks
Comments
No Comments
