Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Migrating SharePoint 2003 database from MSDE to SQL Server

Asked By: Nichole Cole Date: Mar 06, 2006 Category: Sharepoint Views: 267

I'm sure this has been asked before, but I want to make sure I have
the right steps before I do this. I want to migrate the MSDE databases
that are on my existing SharePoint Portal Server 2003 machine to
another server running SQL Server 2000.

I've looked for steps on this and the best reference I have found is
here: office.microsoft.com/.../HA100241281033.aspx

Is there a better resource?

Tagged:migrating sharepoint 2003 database from msde to sql server

1 Answer Found

Answer #1 Answered By: Ariana Christensen Answered On: Mar 06, 2006

This is the main resource that MS points us to. I did a little digging in the WSS 2.0 Admin guide and found this:

www.microsoft.com/.../stsf17.mspx?mfr=true

Which has generally the same content as the other article that you previously pointed to. I also did some searching in the SPS 2003 ADMIN guide and found this (very short and to the point!):

Database server — migrate a single server installation using SQL Server 2000 Desktop Engine to a SQL Server 2000 server on a server farm

Back up everything on your existing database server.
Install SharePoint Portal Server on the newly built server, choosing the SQL Server 2000 option.
Create a configuration database.
Restore all of your components.
Use the Edit button on the Restore tab to specify the settings for each component, including the new name for the server.

This is about all that I could come up with at the moment.. I would imagine that someone would have this process on a blog somewhere..

Didn't find what you were looking for? Find more on Migrating SharePoint 2003 database from MSDE to SQL Server Or get search suggestion and latest updates.