[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 383
  • Last Modified:

WSS 2.0 database restore

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.
1 Solution
Ted BouskillSenior Software DeveloperCommented:
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.
CandeeVAuthor Commented:
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!

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now