I'm interested in this topic as well actually.

What would you do if you had this problem and had large tables?

What makes you so strongly say not to backup a SQL database across the network out of interest?

I've been doing this for a while myself, and found it very reliable...

Thanks for the link, that's really useful. Appreciate that.

ps. (9/15/2011)

---

PhilipC (9/15/2011)

---

Thanks for your help guys.

Turned out he wanted multiple sql instances installed in the same resource group. I didn't think this was even possible. Am I missing something...

Thanks for your help guys.

Turned out he wanted multiple sql instances installed in the same resource group. I didn't think this was even possible. Am I missing something here, is...

Thanks again okbangas & ps.

V1 and V2 will be the SQL Server Network Names with InstanceName1 and InstanceName2 being the actual instance names of the SQL Install.

So you finish up with:

V1\InstanceName1 (Node 1)

V2\InstanceName2 ...

How do you guys handle fail-over on big clusters like that out of interest in terms of what fails over where?

Thanks for your thoughts guys, very much appreciated.

It's all SQL 2008 R2 across the whole cluster, and there is talk about having another 3 node cluster and splitting the...

Thanks for your post Jeffrey, some well made points there.

I think after consideration I'm going to stick with MP within the environment I look after. The databases are quite...

Thanks for your thoughts guys, much appreciated.

Thanks guys.

Yes I'm aware of OLAP v OLTP. I was more wondering towards whether anyone has a standard or best practice for a completely new server where you don't necessary...

Thanks guys, I finished up creating it as a SQL Agent job and giving the person permission to execute the job which has worked fine.

Thanks for the suggestion guys - good idea 🙂

Thanks for the further thoughts guys, much appreciated 😎