The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P152: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 60 Appendix Self Test Appendix However if you bring the database online at this point you will not be able to replay logs into this database. Therefore you must use the NORECOVERY option. Once the full backup has been restored you can replay the tail-log you have just backed up into the database. This time the database is ready to be brought online and you can use the RECOVERY option during the restore operation. Incorrect Answer Explanation D. Answer D is incorrect because marking the database as RECOVERY before you replayed the tail-log into it will bring the database online. Once the database is online you can never replay logs into it. 15. Your organization has headquarters in Auckland New Zealand and branch offices in most countries around the world. Recently you have centralized all SQL Servers on to a single server in Auckland. The main database is accessed by users from every office. The database is large and takes around 20 hours to perform a full backup. Additionally the full backup is detrimental to performance and should be minimized during business hours of any of the offices. You are also aware that your organization cannot afford to lose more than one day s data. Your task is to create a backup strategy that produces the fastest possible restore time meets the recovery point objective and has minimal impact on performance experienced by users. What will you recommend A. Perform a copy-only backup every Sunday and a differential backup every day at the least busy time. B. Perform a full backup every Sunday and a log backup every day at the least busy time. C. Perform a full backup every Sunday and a copy-only backup every day at the least busy time. D. Perform a full backup every Sunday and a differential every day at the least busy time. Correct Answer Explanation D. A full backup every week will happen when there is minimal user activity and has the least potential to adversely affect performance. The differential backup every day will record the .
