Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 43
  • Last Modified:

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
0
CREATiVENESS
Asked:
CREATiVENESS
  • 4
  • 2
1 Solution
 
QPRCommented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now