Unanswered: How to copying system db (master, msdb) to different machine???
I am creating a standby server on a different machine of my production server with the same MS SQL 2005 build, and was wondering if anyone knows how to copy the system database from the production server to the standby server so all the logins, jobs, maintenance plan, etc are copied over to the standby server.
I've tried methods such as putting the server on single user, then restoring the system database and using 'alter database modify file' command to point the standby SQL Server to the system database, but all this does is corrupt it, not allowing me to log into it, which meant I had to rebuild my system database.
If anyone now how to do this or a better way of creating a standby server and have any inputs, it would greatly be helpful.