Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Does config DB get restored

Posted on 2011-03-09
2
Medium Priority
?
408 Views
Last Modified: 2012-05-11
Situation:

Server 1 (Test Environment)
W2K3
SQL Server 2000
WSS 3.0

Server 2 (Production)
W2k8
SQL Server 2000
WSS 3.0

I will be doing the following:
1) Backup(SQL 2000) of Content DB (content.db) to SERVER2
2) Restore(SQL2005) of content.db to SERVER2
3) Create a new Web Application (spwebapp)
4) Attach the content.db to the (spwebapp)

Questions:

1) Will I need to also restore the Config DB or just the content DB
2 ) Does it matter if I restore to SQL 2005? Since the backup is from SQL Server 2000.

Thanks
0
Comment
Question by:fstinc
[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
2 Comments
 
LVL 14

Accepted Solution

by:
KoenVosters earned 1000 total points
ID: 35085571
1. You do not need to restore the config DB.
2. You should restore it to 2000 under a different name, detach it, move it to sql 2005, give it it's original name and attach it to sql 2005
0
 

Author Comment

by:fstinc
ID: 35085609
Clear and straight forward. Thanks man.
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

721 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