Post reply

Transferring SQL User DBs to another Server.

  • January 5, 2004 at 2:42 pm

    #81821

    When transferring SQL User DBs from Server_A to Server_B is it necessary to restore the Master DB (and Model DB) from Server_A to Server_B? Also, are there any other issues (logins, SIDs) that should be considered.

    Is there a website or any articles that provide a checklist for doing this type of thing?

     

  • January 5, 2004 at 3:10 pm

    #488727

    Check this article from MSDN about logins transfer:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

    HOW TO: Transfer Logins and Passwords Between Instances of SQL Server

    It's up to you to decide if you want to transfer master/model/msdb to the new server. I'd just transfer the logins using the above mentioned procedure, but if you have a lot of scheduled jobs, custom alerts, etc. you might want to transfer all system DBs. If you decide to to do that there is another article on MSDN on how to do it step-by-step (I don't have the link handy).

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply