Thanks for your input folks, it gives me something to look into.

S

Thanks, that worked for me.

I had assumed the syntax was correct as the code worked fine within query analyazer.

Thanks again for the help.

Hello folks 🙂

I have spoken to few people about best practice on this. It would seem alot people set up a one node cluster, restore the databases to this...

Thanks for your input, 🙂

I was trying to avoid any downtime, but I agree your solution would definately be the neatest answer.