Sapen (8/25/2014)
But a day/two's worth of data is in the 2012 database and I will have to do a data compare and move over the new records to the 2008 R2 database. And the databases are almost a terabyte and this is going to be a slowprocess.
Yes, that's pretty much what you have to do. Rolling back something like that is not a decision to be taken lightly, it's going to involve a lot of work.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability