Restoring SIMS after complete Disaster recovery to new hardware?
As part of our disaster recovery procedure I thought it would be a good idea to try to restore our SIMS server to another machine and document the process so that if we did, God forbid, have to recover for real, we would know what we were doing!
I have reinstall Server 2003 with ASR on to a workstation my SIMS server set up but I can't access the SQL Database.
SQL management studio will not connect to server\sims instance.
This is where I fall down as I have no SQL training and limited experience with it.
I'm not sure if I just need to restore the databases which have been backed up via script and then i should be able to connect or if I need to set up SQL itself first?
Can anyone suggest how they may have done this or how I could do it?