Solved

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

Posted on 2014-04-02
7
37 Views
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?

Thanks,
Randy
0
Comment
Question by:CREATiVENESS
[X]
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
7 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 500 total points
ID: 39973763
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
 

Author Comment

by:CREATiVENESS
ID: 39975517
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
 
LVL 29

Expert Comment

by:QPR
ID: 39975902
And the second URL I posted showed exactly how to shrink your DBs prior to upgrade
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 29

Expert Comment

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

Author Comment

by:CREATiVENESS
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?

Thanks,
Randy
0
 
LVL 29

Expert Comment

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

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

624 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