Hi

Please follow the steps below

First Update the SP on the Subscriber

Apply the SP2 on the passive node

Failover and Apply SP2 on passive node

Run the update...

It could also be a Disk issue. Please check the Disk on Prod.

Regards

Srikanth Reddy Kundur

Please ignore the message above

Hi

You can create a 2 node cluster and then add the Third one. While adding the Third one to the cluster please uncheck the option to "Add the eligible...

Hi,

It is recommended to run the SQL Services on an AD account.So update them the benefits of using a service account as a standard for all the sql server instead...

Not Required

Regards

Srikanth Reddy Kundur

Not sure but this may help you

http://msdn.microsoft.com/en-us/library/ms142541(v=sql.105).aspx

Thanks

Srikanth Reddy Kundur

This Link might Help you

http://msdn.microsoft.com/en-us/library/ms143393.aspx

Regards

Srikanth Reddy Kundur

Not sure which edition you are talking about

Have a look at the editions available in 2008 and let us know if you any questions

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.100).aspx

Thanks

S.R.Kundur

Changed the code as suggested, the job executes successful but no records are getting inserted, Can anyone help on the script please.

Regards

S.R.Kundur

In a clustered environment you cannot unistall SQL Server unless you remove it from Cluster first.

In your situation,

Step1: Remove SQL Server from Cluster(for doing this run the setup and...

If you made a Force failover and if mirroring is active then there will be enough log on the Old principle server. However if you have a force filover and...

I think the above all is sufficient to get the culprit

but mostly It would be Network Bandwidth

Thanks

S.R.Kundur

I think you are trying to create it from a Different server. Please create the Linked server where you want to connect to the other server. And also make sure...

I think you are trying to create it from a Different server. Please create the Linked server where you want to connect to the other server. And also make sure...

Please check whether the Percentage of restore is happening using

Select percent_complete from Sys.dm_exec_requests where session_ID = --Mentioned the SPID which is in Killed rollback

If the percentage is going up,...