Thank you, All. I solved the prob. Just going to Mirroring Monitor, right click on Database Mirroring Monitor Node and select Manage Server Instance Connections. After that I connected Server...

After configuring mirroring, I opened Mirroring Monitor and I got the following scenarios.

@Principal,

@Mirror,

Though it is shown that "Synchronized" but why is it showing "Not Connected to"? Please let me know...

Thank you, all for helping me.

I have solved the problem. I followed the several ways in both Principal and Mirror Server as follows.

|--Created two new local users Server1\ABC (P) and...

Thank you, Sir. Actually Perry's command worked for me.

Actually my Principal server got down. It will take some hours to be ok. That's why I have to use Mirror database to run my application. In Mirror database it...

standard edition

Now I have done.

I have changed local service account to domain account and created domain account login with windows authentication. That's it.

Thank you all.

Thank you, Boss. I have tried in the way you mentioned. In configuring mirroring I left service accounts box blank. But when I click on Start Mirroring, I get an...

Thank you Lynn Pettis.

I want to configure mirroring default instance (Principal) to default instance (Mirror) and named instance will Witness. Principal will reside on one System and Mirror and Witness...

I am using one PC for Principal and other PC for Mirror and Witness. That means there are two different hardwares. One contain one instance and other contain two instances.

Thank you

Actually transaction log file keeps on growing, so my database file also grows which consumes more disk spaces. To make database size smaller, I shrink log file that serves my...

Thank you dbasql79 for your kind information. I get my problem solved.

Thank You for this information.

Thank all specially Bhuvnesh and Perry Whittle for your kind help.

I have gone through database mirroring configuration and now I will go through how database mirroring works.