Solved

Does config DB get restored

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Running classic asp applications under Windows Server 2008 R2 (x64) and IIS 7 is not as easy as one may think. It took me a while to figure it out while getting error 8002801d a few times. After you install the OS you will need to install the fol…
Prologue It is often required to host multiple websites on a single instance of IIS, mostly in development environments instead of on production servers. I am sure it is not much a preferred solution on production servers but this is at least a pos…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

912 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

23 Experts available now in Live!

Get 1:1 Help Now