For which of the following should you use Windows backup utilities to perform a backup? Choose all correct options.
A.
System state data.
B.
System boot files.
C.
Microsoft SQL Server files.
D.
All of the above
Explanation:
System state data should be included with all other critical data being backed up. You should select the option in the Windows backup utility to include the system boot files when you back up system state data.
Incorrect
Answers:
C: 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 should be used to back up Microsoft SQL Server files and database 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.