Solved

Migrating Sharepoint 3.0 Internal DB to SQL 2008

Posted on 2010-11-14
6
641 Views
Last Modified: 2012-05-10
Lots going on here which is making resources fairly difficult to find. I have the following configuration:
MS Sharepoint 3.0 running the internal database on a Windows 2008 Server 32-bit
SQL 2008 Standard running on Windows 2003 32-bit

I would like to migrate the content DB from WSS to SQL 2008 so I can really do some in depth reporting using SQL reporting services.

Should I do a detach and reattach? Restore from a WSS backup to SQL 2008 (is this possible)? Do a backup and reinstall everything properly with the database config?
0
Comment
Question by:LeifHurst
[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
6 Comments
 
LVL 8

Expert Comment

by:static-void
ID: 34133915
Personally i would back it all up then do an upgrade on your sql box, its worked for me in the past... the other options will both work, personally i prefer backup restore.
0
 
LVL 8

Expert Comment

by:static-void
ID: 34133929
oh actually one thing you should know is that you can only really backup and restore content databases. this means you need to reconfigure your farm which may be un-desirable
0
 
LVL 8

Expert Comment

by:static-void
ID: 34133953
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 3

Expert Comment

by:nishant_shah_2002
ID: 34134209
0
 
LVL 43

Accepted Solution

by:
zephyr_hex (Megan) earned 500 total points
ID: 34137995
you said:
"MS Sharepoint 3.0 running the internal database on a Windows 2008 Server 32-bit"


this means that you'll need to uninstall and re-install sharepoint. when sharepoint uses its internal db, it gets installed as standalone.  in order to use something other than the built-in sql, you have to uninstall, and then re-install using the farm/advanced option.  even if the full sql version is on the same server as sharepoint.

as for the steps to get the content from the internal db to full sql:
http://technet.microsoft.com/en-us/library/cc262018%28office.12%29.aspx

0
 

Author Closing Comment

by:LeifHurst
ID: 34179980
This worked for us. Uninstalled everything and restored the content databases to our SQL server. Went ahead and took this time to upgrade everything to 64-bit as well.

Thanks again!
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql query help 15 55
Compare a column in results by values left of decimal 2 22
find SQL job run average duration 24 57
Sharepoint question : What is a Simego cube 4 19
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

730 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