For one of my client a tech went on site to upgrade SQL and things didn't work the next day. After looking into it I had thought he had just installed SQL server 2008 R2, but not upgraded any instances or the Management Studio. So I fixed the management studio and upgraded that.
Then I ran SQL 2008 Express Edition with advanced Services again and choose to upgrade from 2005. The Rule Check failed on "Previous version"
After digging through forums and looking at other peoples similar issues there appear to be some registry keys. When I was looking into this I realized there is an entry for "MSSQL10_50.instance" and it shows the old 2005 database that it upgraded from etc. However this instance doesn't actually exist so I'm guess this is the failed previous upgrade. The original 2005 database is running and working.
I'm wondering if I can delete the entire Registry folder for teh failed instance and the directory with all the files for it and try again. Would that clear the failed previous upgrade? or would it cause complete Chaos of some kind I don't know.
in the end I had no luck. I didn't have another server to test with and ended up doing this:
It's a sledgehammer,
Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes.
Assigning simple products to configurable: We assigned simple products…