I hope somebody may be able to help me with this one, heres the scenario surrently i have 2 apps running on different SQL 7 servers. As a method recovey i want to place these two apps on a backup server away from the main LAN. So basically i wish to know if it is possible for me to copy these two SQL based apps and put them onto a single server, and if so how would i do it?
I suppose really what i want to do is to have the two apps on a standalone server somewhere so in the event that i need to be up and running quickly i could switch on my backup server, restore the app data and hey presto away we go.
Anybody any ideas, as you may have guessed i am not that familar with SQL