Instead of having the log parser on each server, you may have each server configured so sql server error messages are forwarded to a single server where the log parser...

I am unable to see the code posted on this article. What is the problem with the web page? I clicked on the link for the txt file and all...

Thanks ChrisMoix. The ownership issue is the key.

Replication cannot be an option because there are 8 databases and the link is slow.

Thanks to everyone for the insight provided. I now...

Thanks. But I do not understand what you mean by the statement below:

The data drive is shared but is dedicated to the instance. The data drive is not shared...

Thanks for pointing out this. I remember now that there will be one default and one instance databases in an active/active cluster. In that case each site application can be...

I just do the normal restore of a dtabase from EM br right clicking a database and selecting restore database. As soon as this is done, I get the above...

The point is that there are 2 secondaries and one of them has been promoted to primary using the script you mentioned. So how does the second secondary server establish...

If I understand your problem very well, it looks like something i have experienced alog time ago. I can't remember all the details now but I can pouit you in...

Thanks all. I have resolved the problem by using sp_attach_db to re-attach instead of using EM.

Yes. The listing of what is on sqlsp.log on the second note is reproduced belwo. Thanks.

======================================

16:39:58 Begin Setup

16:39:58 Version on Media: 8.00.760

16:39:58 Mode = Normal

16:39:58 ModeType = NORMAL

16:39:58 Begin: SetupInitialize()...

These are the last few lines of the sqlsp.log. The installaton is still failing with the same error.

Installing remote service ()...

CRemoteProcess::RunUntilComplete [0x8c] error code: 53

CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 53

CThreadPool::RunUntilCompleteHlpr signaled thread...

You only need Visual Studio.NET if you are going to design your reports from the server. You can ignore this. The clients however require Visual Studion.NET. The report designer uses...

I have just resolved a similar situation because ofa third party software (CRM) that requires a specific collation.

I used rebuildm and is quiet easy if you know what to do...

Thanks Steve. That is what the error will suggest but when i try to manually restore the log backups it keeps failing either because the log is too early or...

Just resolved this issue by installing MDAC version 2.7 before installing the service pack  3a. Just in case anyone else get this problem.