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

Posted on 2014-04-02
Last Modified: 2016-06-04
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?

Question by:CREATiVENESS
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
LVL 29

Accepted Solution

QPR earned 500 total points
ID: 39973763
Here are the options/steps for the upgrade itself

Very large config DB is a known issue try this URL

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

Author Comment

ID: 39975517
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.

LVL 29

Expert Comment

ID: 39975902
And the second URL I posted showed exactly how to shrink your DBs prior to upgrade
Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

LVL 29

Expert Comment

ID: 39975906
And I have shrunk thousands of transaction logs I am a DBA by trade

Author Comment

ID: 39976930
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?

LVL 29

Expert Comment

ID: 39976962
Attach! The in-place upgrade creates nightmares (personal experience) in fact I think they dropped that option in 2013

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server 2012 to SQL Server 2016 24 55
HIghlights of SSIS? 3 44
SQL Server Pivot 5 42
Sql group by orderdate and ordertotal 3 9
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question