Solved

Does config DB get restored

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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
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.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

762 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now