Preparations
1. Open the old website and add the administrator of the new domain to the administrator of the website set of the old website.
2. Stop the SQL2005 Service
3. COPY the content database of the website to the server of the new domain.
4. Open the SQL2005 management tool on the New Domain Server to append the copied content database (if the same database is used, this step can be omitted)
5. Grant the owner permission to the new MOSS database access account
6. Install MOSS on the New Domain Server. Be sure to install all updates on the old server.
Start Transfer
7. After configuring the new MOSS, create a Web application. The name of the website's content database should be the same as that of the original content database, in this way, the website of the old domain can be moved to the new domain.
All functions have been tested to work properly. Environment: MOSS2007 + SQL2005 + Win2003
Reprinted from: http://endian.blog.51cto.com/150340/113802