Create identical SQL 2005 server

By CanadaDBA ·
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?


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums