asked on

Moving SQL Database from old server to new server

Hie there. I would like to move an SQL database from the olld server to a new server. The software on the old server is the same on the new server except the hardware. When moving the database i don't want to lose the permissions/privelges of users in the database. the database is also going to be used on a different domain. is there a tool to do this or is it simply backup database on old server and restore on new server?

Thanks

ptjcb

Either backup/restore or detach/attach are the best practice methods.

I would check the user's rights/privileges because you are changing domains.

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

Especially read this section:
Review the output script carefully. If server A and server B are in different domains, you have to modify the output script. Then, you have to replace the original domain name with the new domain name in the CREATE LOGIN statements. The integrated logins that are granted access in the new domain do not have the same SID as the logins in the original domain. Therefore, the users are orphaned from these logins. For more information about how to resolve these orphaned users, click the following article number to view the article in the Microsoft Knowledge Base:

It also has links for orphaned users.

David Sairai

ASKER

thanks ptjcb. i will work on your advice plus a couple others i got. will let you know the results.

David Sairai

ASKER

thanks. it worked after all. database is ok after a couple of amendments but thanks to you.

bye

ASKER CERTIFIED SOLUTION

ptjcb

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial