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

x
  • 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 6.0.2.6568; the database is 6.0.2.8117. 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.
0
CandeeV
Asked:
CandeeV
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.
http://technet2.microsoft.com/windowsserver/WSS/en/library/f9f9a3eb-ce46-4dbb-a15c-9fad9eb32ec71033.mspx?mfr=true

You can install WSS 3.0 with preinstalled databases:
http://technet2.microsoft.com/windowsserver/WSS/en/library/f7772626-cc01-4698-9dd8-958e60f7cb201033.mspx?mfr=true

I've found other articles online for preinstall databases on WSS 2.0 as well.
0
 
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 6.0.2.6568 to 6.0.2.8117.
Thanks for helping!
0

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