SQL SERVER – Database Mirroring and Fine-Prints – Quiz – Puzzle – 23 of 31

Click here to get free chapters (PDF) in the mailbox

Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to the next level. Here is an article which discusses the Author’s Perspective.

Beyond Relational has come up with a very interesting concept – they have converted a few of the questions from my book into the SQL Quiz. The quiz is indeed focused on my two goals. In addition, it’s going to put the learning of the book to a higher stage. Looking at this novel concept, Vinod Kumar (Co-author) and I have decided to help every participant and reader by giving a few hints and suggestions to solve the quiz.

SQL Quiz

SQL SERVER - Database Mirroring and Fine-Prints - Quiz - Puzzle - 23 of 31 23 Though high availability is something critical for all large database deployments, there are other multiple options one can use. For today’s discussion, what is database mirroring option? What are the Database Mirroring enhancements done in SQL Server 2008 R2 edition? How is it different from Log shipping?

Link to participate in SQL Quiz

Notes of Vinod Kumar

DBM is a very famous method of HA options that I have seen enterprises use in their environments. The concepts are simple and well-explained. There are also fine-prints when implementing DBM, which need special attention.

Notes of Pinal Dave

“Is database mirroring a high-availability solution, or a disaster recovery solution?” When I ask this question, I keep on getting a different answer every single time. Database mirroring maintains two copies of a single database that must reside on different server instances of SQL Server Database Engine. Now, mirroring requires that the database has to be in full recovery mode and the database resides on different instances. A lesser known fact is that mirroring is also related to the Page Restore concept. Why not spend time to know what the main interesting factors related to database mirroring are? I’m sure it would be a worthwhile learning experience for you.

Additional Notes

SQL Server Interview Questions and Answers ISBN: 1466405643 Page#158-159, 166
Quick Note of Database Mirroring
Standby Servers and Types of Standby Servers
Mirroring Configured Without Domain

Prize

There are exciting prizes awaiting the winners. Click here for Prizes and Frequently Asked Questions.

Link to participate in SQL Quiz

Note: SQL Quiz, winners and prizes are administrated by Beyond Relational. The goal of this blog post is to provide additional learning pointers only.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – What is Piecemeal Restore – Quiz – Puzzle – 22 of 31
Next Post
SQL SERVER – Correct Value for Fillfactor – Quiz – Puzzle – 24 of 31

Related Posts

No results found.

1 Comment. Leave new

  • Virendra Yadav
    June 1, 2019 9:12 pm

    Declare @FullPathRestore nVarchar(max)=’N”D:\TransactionLIVE\’+2019_06_01_210001_9310832.trn+””
    Select @FullPathRestore

    Declare @FullPathRestoreString nVarchar(max)=’
    RESTORE LOG DB FROM DISK =’+@FullPathRestore+
    ‘ WITH RESTRICTED_USER, FILE = 1, STANDBY = N”D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\ROLLBACK_UNDO_DB.BAK”,
    NOUNLOAD, STATS = 10’

    Exec sp_sqlexec @FullPathRestoreString

    Disconnect users in the database when restoring backup

    Reply

Leave a Reply

Menu