May 20, 2004 at 10:25 pm
server "A" and Server "b" Sever "c" in same LAN AND NEED TO CREATE A VERY NEW SERVER "D" and will be transfering all user db's and combine and make one sql server.
I need to know how i copy master.mdf of all 3 servers and copy to the last server and get all server login information as well?
Oh else is it not recommend to restore one mastter on to another.
cham
May 24, 2004 at 7:15 am
http://support.microsoft.com/default.aspx?kbid=246133
Very good article (above) for moving Databases (and user Schema) between SQL Servers. I use the sp_help_revlogin script all the time to document (and move) users from Server to Server. the output of the sp_help_revlogin script can be used to recreate Logins with the same SID and password on another Server.
I know that doesn't address your entire question - but I hope it helps a little.
May 24, 2004 at 8:40 am
The references above are great. I wouldn't move master, just move the databases and use sp_help_revlogin to get the logins. You might need to use sp_change_users_login to synch them up once you're done.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply