Restore log myadvworks from myadvworkslog1 with

This preview shows page 15 - 18 out of 19 pages.

RESTORE LOG MyAdvWorks FROM MyAdvWorks_log1 WITH NORECOVERY; GO RESTORE LOG MyAdvWorks FROM MyAdvWorks_log2 WITH RECOVERY; GO References: - backup-sql-server QUESTION 11 You administer a Microsoft SQL Server 2016 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database. The recovery model and backup schedule are configured as shown in the following table: Latest 70-764 Dumps | 70-764 Study Guide | 70-764 Braindumps 15 / 19
Image of page 15
2019 Latest pass4itsure 70-764 PDF and VCE dumps Download At 16:20 hours, you discover that pages 17, 137, and 205 on one of the database files are corrupted on the transactional database. You need to ensure that the transactional database is restored. You also need to ensure that data loss is minimal. What should you do? A. Perform a partial restore. B. Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup. C. Perform a point-in-time restore. D. Restore the latest full backup. E. Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup. F. Perform a page restore. G. Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup. H. Restore the latest full backup. Then, restore the latest differential backup. Latest 70-764 Dumps | 70-764 Study Guide | 70-764 Braindumps 16 / 19
Image of page 16
2019 Latest pass4itsure 70-764 PDF and VCE dumps Download Correct Answer: F The goal of a page restore is to restore one or more damaged pages without restoring the whole database. Typically, pages that are candidates for restore have been marked as "suspect" because of an error that is encountered when accessing the page. Note: Requirements for Restoring Pages A page restore is subject to the following requirements: The databases must be using the full or bulk-logged recovery model.Etc. References: QUESTION 12 Note: This question is a part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question. You are designing a new high availability (HA) solution for a set of application databases. The solution will be contained within a single datacenter and provided instance-level HA protection.
Image of page 17
Image of page 18

You've reached the end of your free preview.

Want to read all 19 pages?

  • Fall '19
  • Microsoft SQL Server

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors