actually witness server is an optional requirement in mirroring. If you choose "High Safety With Automatic Failover" option, then you need a witness server.

Thank You, Perry Whittle. But what does "database will be totally out of sequence" mean?

Thank You, Bhuvnesh. Now I am clear.

I installed three instances of sql server in my PC. One was default instance and others were named. I configured default instance as "Principal" and one of the named instances...

Actually I can not clarify myself.

Say, I configured mirroring on 10 November. That means I backed up database and log from principal and restored to mirror with no recovery on...

For mirroring, I have gone through the following steps.

1. backed up database from principal

2. backed up transaction log from principal

3. restored database to the mirror with no recovery option

4. restored...

If I restore database on principal, then what steps should be taken to maintain mirroring? Do I need to do anything on mirror database?

Please help me.

Thank you, so nothing to be worried.

Actually I am using Standard Edition, so can not create database snapshot.

I went database mirroring monitor and found "Synchronized" from Mirroring State column of both of the server instances.

Does it...

Thank you. I will do that.

Actually I do not take transaction log backup. But I take full database backup everyday.

Is there any inconsistency in my backup activities? Why is transaction log backup necessary?

Please let...

Yesterday I shrunk transaction log file. After shrinking, my drive's free space was increased to 270 GB. But before shrinking it was 240 GB.

So what's the matter?

@Gila Monster,

Thank you Boss, I will implement Mirroring.

Because free disk space is decreasing day by day. Say, I...

Thank you Jeff Moden. I will change the growth strategy from auto growth to MB growth.