Ok- let's make it simple. When I login to node b (xyzdb01b) and in configuration manager/services all I can see is named instance service not MSSQLSERVER services. And when I...

Yes, I failed over to node B and I do not see the default instance. On node A we have default instance/customer database and on node b we have named...

What do we do afterwards?

Thank you so much for your reply-

Thank you somuch for the respond....

Thank you somuch guys, but I need to find out where do we use the 'service accounts' besides to the specific services? For example, if we use this service account...

Any video link on this subject?

Pradeep,

Hi

Can you please send me link or steps to apply the service pack2 on sql 2008 cluster failover. I need to see step by step guide or video. Thanks!

Thanks for the reply, but do you recommend any link that shows step by step procedure.

No, it's not working. Node a is invisible and some of the binary files got corrupted.

Thanks, but we have active/active nodes. Do you any link to install sql 2008 sp 2 for active/active nodes?

Thank you so much for the reply. I need to print allocated space (w log) and allocated space (w/o log) If you have some scripts or the site please provide...

We work for some government contract and the the audit people asked this question to make sure if we have a seperate account for software installation.

Thank you so much for the reply, but all its showing is administrator. I want to see owner as prod\hydbadrose1...

Thank you so much all for the reply! So it rolls back even for the job fails for some reason?