Migration options from sharepoint 3.0 to 2010 with Large Db's

I am looking for the best options to upgrade/migrate from 3.0 to 2010 with DB's that appear to be in the size of

Search - 1gb
Config - 33gb
Sharewebdb - 42gb

I am not sure why it is so large since it is not a big company but this seems to be huge.
I am wanting to do a db attach option to upgrade and I think i can do this if I upgrade to sql server 2008, but i am not sure if this would still be to large.
What are the best options to do this upgrade?

Thanks,
Randy
CREATiVENESSAsked:
Who is Participating?
 
QPRConnect With a Mentor Commented:
Here are the options/steps for the upgrade itself
http://technet.microsoft.com/en-us/library/cc303309(v=office.14).aspx

Very large config DB is a known issue try this URL
http://felixyon.blogspot.co.nz/2010/06/shrinking-sharepoint-config-db-log-file.html

It also helps with Sharewebdb

My guess is that a majority of your DB size is due to timer job history and/or transaction log size. You'll certainly want to address these sizes before an upgrade
0
 
CREATiVENESSAuthor Commented:
Hi QPR,
Thanks for the info, I am aware of the different options for the upgrade but my question is what is the best option when dealing with large dbs.
I was hoping to get an opinion from someone who has actually done this also since everywhere I read tells me that it may or may not fail if I have sql server 2008 instead of express.
I am working on shrinking the dbs as it says.

Randy
0
 
QPRCommented:
And the second URL I posted showed exactly how to shrink your DBs prior to upgrade
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
QPRCommented:
And I have shrunk thousands of transaction logs I am a DBA by trade
0
 
CREATiVENESSAuthor Commented:
Thanks qpr, I was able to get it down to about 3 gb's.
Any idea if the database attach or the in place upgrade is the better option for me now?

Thanks,
Randy
0
 
QPRCommented:
Attach! The in-place upgrade creates nightmares (personal experience) in fact I think they dropped that option in 2013
0
All Courses

From novice to tech pro — start learning today.