Hi, I have been asked to provide some sort of disaster recovery for our payroll system which has databases running on SQL Server 2005. As I haven't looked at SQL Server since about 1998 things are a bit foggy!
I'd really appreciate some advice on the best solution and how to go about implementing it.
I have determined that all that is required is a daily copy of the databases to be copied from the primary SQL server to a secondary SQL server, and be accessible from there if required. Also obviously once the issue with the primary SQL server is resolved
there will be a requirement to overwrite the existing databases on it with the newly updated ones on the from the secondary SQL server.
I have looked at mirroring and think that's a bit above what I need, and at replication but don't know if that is the right solution either (I have tried setting replication up but doesn't seem to want to work). I then looked at just copying the databases
but wasn't sure if the secondary SQL server setup had to be identical to the first.
Basically any advice gratefully received and pointing me in the direction of any good reading material on the subject would also be of immense value.
View Complete Post