• houming1982 (4/19/2013)


    Unfortunately, in that case you'll need to go through the failover process.

    Wish you could specify the owner as part of the restore statement but no joy. Not sure if 'execute as' would work but I wouldn't count on it 🙂

    Thank you very much for your reply, Gazareth. I tried with "execute as login = 'A'", then restore backup and log by commands (the prerequisite is that login "A" has the same permissions on both servers), and it works! 😀

    Cool, did not expect that to work! Good one to remember! 🙂

    Cheers

    Gaz