Solved

Does config DB get restored

Posted on 2011-03-09
2
397 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 250 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…

752 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