I am at total lost at trying to copy system db(master, model, distribution, etc) from a 2005 server on one machine to another 2005 server on a different machine, so all the logins, job, etc are also copied to the new server.
I have tried to google this problem and am at a lost to how to do this. Is possible to even do this, if it isn't can someone please suggest a good practice at how I should go abouts at create a standby server from a production server.
Basically what I have now is a script to copy and restore all the user dbs on the prod to standby server, but what about the logins, jobs, alerts, replication data on the production server, how do I go about copying these over so the standby server will still function?
I am really at a lost so any input and idea will be greatly beneficial to me.
October 9, 2008 3:38 AM
October 9, 2008 1:23 PM