That surely explains it. Thanks, Gail! -Yuemo

I have a similar/related question. What happens when the mirror server is down AND t-log is backed up before the mirror comes back?

For example, in the case of high safety...

Thanks, that makes sense!

I re-read the section of mirroring. I missed that part.

Our application is not suitable to failover automatically. This is why I did not add the witness, as...

Well, we were trying disaster recovery test to simulate one server down.

So if the principal is down, how to make mirror into production?

Thanks,

-Yuemo

Sorry, I may not explain it clearly. Here are the routes I tried.

1. Use domain account to run db engine service, the service will not start. So installation can not...

Thanks for the link, I will look for details. http://support.microsoft.com/kb/283811.

This afternoon, I did more work. The problem seems in sp2.

I have to install as local system to start the service....