Upgrade to SharePoint 2010, on a new environment using Database Attachment method

Install and configure SharePoint 2010, on a new environment:

• Determine hardware and software requirements
   http://technet.microsoft.com/en-us/library/cc262485(office.14).aspx

• Planning Logical architecture components

   http://technet.microsoft.com/en-us/library/cc263121(office.14).aspx

• Deployment guide for Microsoft SharePoint Server 2010

   http://technet.microsoft.com/en-us/library/cc262957(office.14).aspx

After installing and configuring your new SharePoint 2010,

Moving Content Database from SP 2007 to SP 2010:

• Find the content Database; these are listed under Central Admin->Application Management->Site Collection List.

• Backup the content database, you could alternatively detach it, and copy it. Just doing a backup in SQL Server Management studio is easier.

• Restore content database to new server, Copy the BAK file to new server. Create an empty DB in Management Studio, restore from backup, you may need to change an option in the "options" tab of the restore dialog to get it to work. (Overwrite db).

• Create Web App on SharePoint 2010.

• Remove Content Database from the new web app.

• Now use STSADM to add restored DB to this web app from c:\program files\common files\microsoft shared\web server extentions\14\bin on new server and Run this Command which will upgrade the content db to 2010.

stsadm -o addcontentdb -url http://yourwebapp:port -databasename yourcontentdb -databaseserver yoursqlserver

• Run ISSRESET from command prompt.

(Part 1) & (Part 2)