No, Mirroring is a DR solution. I believe you cannot use Mirroring for load balancing. If something goes wrong with Principle Server, you have the Mirror DB to...

Yes, maintenance plan would work.....there are some nice videos in youtube which shows how to create it.

Well, index helps to read data faster. There are two types of indexes, Clustered and Non-Clustered Indexes.

Clustered Index - provide the actual data page at the leaf level of...

1.What is mirroring and how would you configure mirroring?

•Database mirroring is a primarily software solution for increasing database availability. Mirroring is one of the disaster recovery solution and this feature...

Thanks Brandie & Bob, Appreciate your help.

My apologies, will do my homework next time before asking for help.

Take Care.