Post reply

Copy DB from SQL 2k to 2005

  • September 20, 2007 at 7:01 pm

    #177186

    I haven't seen the SQL 2005 Enterprise interface yet. I intend to use the copy database wizard to copy a DB from a SQLServer 2k to 2005 from one server to another.

    My question is does the copy process incorporate moving SIDs?

    Thanks,

    Bruce

  • September 20, 2007 at 7:10 pm

    #735103

    You meant moving logins probably; you would have to move logins as a separate task as they are stored into master db. please read here how to do this

    http://support.microsoft.com/kb/246133/

     

  • September 20, 2007 at 8:07 pm

    #735104

    Yes, I meant logins with SIDs. I've had trouble with this before where the logins came across but not the SIDs and I had to re do each one.

    That did answer the question though, thanks

    Bruce

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

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