For which of the following is using Windows backup utilities not recommended for performing a backup?
A.
System state data.
B.
System boot files.
C.
Microsoft SQL Server files.
D.
All of the above.
Explanation:
You should not use Windows backup utilities to back up Microsoft SQL Server files and database data. Microsoft SQL Server includes a specific backup utility which you should use to back up Microsoft SQL Server files and database data.
Incorrect
Answers:
A: System state data should be included with all other critical data being backed up. You should specify in the Windows backup utility to include system state data in the backup.
This is done by selecting the appropriate option or setting within the Windows backup utility.
B: You should select the option in the Windows backup utility to include the system boot files when you back up the system state data.
D: Microsoft SQL Server files and database data should be backed up using the backup utility provided by Microsoft SQL Server.
References:
Charles J. Brooks, Server+ Certification Exam Cram 2 (Exam SK0-002), QUE Publishing, Indianapolis, 2006, pp. 439-440.