Upgraded SQL. Yes, there are pre-upgrade backups. However it was weeks of use before they tried a function that was incompatible. So if we revert to the backups, they lose weeks of work.
On Fri, Dec 13, 2013 at 3:31 PM, Richard Stovall <[email protected]> wrote: > They upgraded SQL, or the OS, or both? > > There are no pre-upgrade db backups? > > I must be missing something. (Not at all unusual...) > > > On Fri, Dec 13, 2013 at 3:25 PM, Kevin Lundy <[email protected]> wrote: > >> Hi All >> >> I have a client that upgraded a database from 2008 to 2008 R2. It took a >> while, but eventually their primary application proved to be incompatible. >> They get a fail because they didn't read the compatibility guide and didn't >> adequately test. But that is why they are now a client. >> >> I know you can't restore to an older version. >> >> I've found a few references to using Enterprise Manager "Generate >> Scripts" with some advanced options. I've tested on some simple databases. >> >> Has anyone done this on a fairly large complex database? Aware of any >> constraints, issues, etc? >> >> How about alternative methods or tools? I've seen a couple of references >> to using Redgate tools - I have a call into them. >> >> Thanks >> Kevin >> > >
