WSS 2.0 database restore

Posted on 2007-07-23
Last Modified: 2008-09-19
I was migrating my WSS 2.0 site to WSS 3.0 with a SQL 2005 backend. I followed the kb for installing to a server farm, and  used OSQL to detach the database (and saved an extra copy of the .mdf and .ldf just in case).
The migration went badly; and I decided to restore the original files. I copied the detached databases back to the server and tried to reattach them using osql.
I keep getting an error that the database is a newer version than WSS.
I completely uninstalled IIS, WSS 2.0. I then installed each patch for WSS and then checked the version in IIS. The IIS version is; the database is I found several posts that kb924881 and then a -forceupgrade would bring it to .8117, but that didn't happen
Anyone have any ideas?
I managed to attach a copy of the .mdf to the SQL 2005 server; the data is *there*, but I haven't been able to extract it; or attach it to the other server running WSS 3.0
At this point I have exhausted all my ideas.
thanks everyone.
Question by:CandeeV
    LVL 51

    Accepted Solution

    Have you been using stsadm on the command line to manage the database?  If not that is one problem.

    You can install WSS 3.0 with preinstalled databases:

    I've found other articles online for preinstall databases on WSS 2.0 as well.
    LVL 1

    Author Comment

    Thanks for the thoughts!
    Yes, I've been using stsadm to manage the databases; I'll check out the preinstalled document.

    I have installed a temporary server to try to restore the original database to WSS 2.0 for now; I followed Mike's list of versions; installed both KB900929 & KB924881, but still can't get the http header version is IIS to go from to
    Thanks for helping!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    779 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

    11 Experts available now in Live!

    Get 1:1 Help Now