I need to recover a WSS 3.0 SP1 installation, the front end web server has died.
The back end (database) server is still up and running, and I managed to take a full stsadm backup 2 days ago before the server died.
What is the best way to get this back up and running. I'm thinking a restore from the stsadm backup is best, but I don't want this to overwrite the current databases, is there a way to specify a new SQL server to recover the databases to?
Essentially, I would like to recover from FEServer1 & DBServer1 to FEServer2 and DBServer 2
If there is a way to just attach a new front end server that may be better, I have tried this and couldn't get it to work. When I try to attach to an existing farm I get the database options of "SharePoint_AdminConfig" with a username of "domain\user", using those credentials is OK but errors at stage 2 of 8 with "An exception of type System.ArgumentException was thrown",
or "SharePoint_Config" with a username of "computer/old domain\user", these credentials don't exist and I don't seem to be able to use different (domain) credentials.
I realise this is sketchy, this is a legacy system which was set up by a guy who is no longer with the company, with no documentation.