Both are two different server with configuration. But on the second servers there are 2 instances.

One more thing, the second is not at all running on the second box.

Thank you.

19019Failover"[sqsrvres] CheckServiceAlive: Service is dead

19019Failover"[sqsrvres] CheckServiceAlive: Service is dead

19019Failover"[sqsrvres] OnlineThread: Error 1 bringing resource online.

19019Failover"[sqsrvres] OnlineThread: service stopped while waiting for QP.

19019Failover"[sqsrvres] CheckServiceAlive: Service is dead

19019Failover"[sqsrvres] CheckServiceAlive: Service is dead

3449ServerSQL...

Thanks for the responses.

Do i need to keep this enabled ? If i disable it, if there any impact on sql server. From sql server perpective, how it is...

Thanks Gail.

Makes sense. Thanks Gail for the clarifications. 🙂

Thanks Mike sharing your thoughts.

Thanks grant. Thanks for the help.

Restart worked. Thank you.

Hi Raj,

i am using

use master

go

create database db1

go

But , what is the need in changing the default locations?

Awesome. Thanks for sharing the information Lowell.

Hi Lowell,

This is working perfectly. I am using sql 2005 and sql 2008. However i have few questions.

1. How to unmark the stored procedure as system proc if i want....

I have tested few things at my end. Just wanted to check is there any other better ways to handle it.

way-1

EXEC sp_MSforeachdb 'SELECT ''?'', SF.filename, SF.size FROM sys.sysfiles SF'

...

Thank you for all suggestions

have you prefixed the new db on to the query

oldmasterdb.sys.sql_logins

I have done that so that sql can pull information from the restored master db. However, that does nt work...