I need step by step instructions on upgrading from Sharepoint 3.0 with an internal database to a new Windows Server 2008 R2 64-Bit Enterprise server. My current Sharepoint 3.0 resides on a Windows Server 2003 R2 Standard 32-bit server. My current sharepoint internal database WSS_Contents database is almost 2GB in size. For some reason, the logs are quite large though, they are about 14GB in size. Either way, i'm not sure if the size of the logs matter. I think only the WSS_Contents database matters.
I would like the simpliest way of migrating to the new sharepoint foundation 2010 server. I dont mind migrating the current internal database data to a full SQL server that resides on a different server if its possible. I already attempted to create a new 64-bit server with sharepoint 3.0 y64-bit version and detach the database from the old server and re-attach it to the new server, but I received an erro when browsing to the sharepoints site. I also attempted to backup the current sharepoint database using stsadm and restoring that same backup on the new sharepoint 3.0 server but that did not work. I got errors. My intention was to install the same sharepoint 3.0 on the new server and then upgrade sharepoint to foundation 2010, but that didnt seem to work. I would really appreciate the help!