The other thing you may need to re-check before configuring Database Mirroring is the DNS lookup. Make sure your instances get resolved from the DNS server, and both the instances...

Are you using domain user account for SQL Server Services? If yes, its better you configured Mirroring with Windows Authentication. The only thing you need to do is to add...

Then you can go with certificate based configuration. check my previous post for the link. Am never deployed with certificate but yes, planning to learn it... 🙂

You need to use certificates if you are using SQL Authentication, however, since you are in a domain environment, I suggest you to use Windows Authentication for database mirroring. I...

Yes

Here is a link for the step-by-step guide on How to Configure Database Mirroring?

Hope, this may help.

Hello Anjali,

You can have only one database mirroring endpoint per instance. So you should use the...

You need to execute the following code for the failover; however, as the database mirroring...

A Differential backup contains all the changes made to the database since the last full backup.

A Transaction log backup contains all the changes made since last full/diff/t-log backup.

Hello Rishitha,

First of all, add the database engine account of the Primary server on the mirror server. To do that, connect to the mirror instance using SSMS, then expand Security...

As Steve mentioned, you can not directly access a mirror database, it will not allow any connections. However, you can create...

It is correct.

TRUNCATE is a logged operation, can be rolled back. Check the following article[/url] from MVP Pinal Dave.

You can not logged in to SQL Server, until you have a vaild login...

Hello Rishitha,

1. Check whether the database...