SQL Server Performance

How to convert a SQL 2000 DB

Discussion in 'SQL Server 2005 General DBA Questions' started by exBK, Nov 21, 2005.

  1. exBK New Member

    I would like to move a SQL 2000 DB to SQL 2005 Enterprise Edition. My SQL 2000 DB already has a few users in it. When I do a full-backup in 2000 and restore into 2005, the users are not accesible. I can't drop those users in 2005 as these users own a few objects. Is there a simple method that allows us to take a full backup of 2000 and migrate to 2005? I have tried Copy DB Wizard and it fails in the last step (I get a Package Error). TIA for your time!
  2. mulhall New Member

    Are the users windows or SQL ,and are you moving domain as well?
  3. exBK New Member

    They are SQL users.
  4. mulhall New Member

    The user accounts will be orphaned, you need to use CREATE LOGIN.
  5. mulhall New Member

    Oh sorry, you can use the Copy Database Wizard to copy the metadata from the old Master at the same time - this will recreate the logins in 2005 also.
  6. exBK New Member

    Thanks that worked!

Share This Page