I have 2 of these clusters on one that worked yesterday, there are 2, only 1 of the nodes (the one that the original install of the cluster was done),...

Ok mirroring went out the window as a choice the vendors app has 8 databases

Could I not setup another instance on the existing clusters and log ship/mirror to that node?

I forgot to add important point, the db names will be the same at the 2 locations

I have a script that does rebuilds on only indexes that are needed, need one for stats that does the same

Would everyone agree to rebuild all stats at least on a weekly basis?

Fixed it by using IP instead of name.

can't do that have to use openquery or it will ignore indexes

Thanks I was missing the rpc setting

Sorry all of these solutions should come after profiler, it may be something as simple as a login issue,start simple first

new column will do diligent testing

Is it tsql which it dies on, 1st maybe load sql mgmt studio on web server and run the sql statements and see if you get a time out. ...

No time is becoming an issue the complete delete and reload takes 3 hours and these are flash drives

Just did one, don't make any mistakes, if you have any errors in initial install a pain to fix. Also understand the coponents, RS is not clusterable, you can...

thanks that is what we are doing