Create identical SQL 2005 server - TechRepublic
Question
September 3, 2008 at 09:46 AM
canadadba

Create identical SQL 2005 server

by canadadba . Updated 17 years, 11 months ago

I am building some DR boxes and want to copy DBs, jobs, logins and everything from prod into initial DR box.

For SQL 2000 I used to stop prod and copy whole System and User DBs physical files into new server on the same path. Then by running some small scripts, the new server was up and running. Of course both servers were identical from the partition point of view, Path, and SQL SPs, etc.

This time I want to do the same work but with SQL 2005. I am not sure if the above solution works any more. If it doesn’t, how can I implement the work?

Thanks,

This discussion is locked

All Comments