December 22, 2004 at 8:32 am
I’m an idiot, I admit it. Here's my other problem.
On 12-14 I moved all my data to and installed SQL Server on a a new server. On the old server I did a backup using the backup tool and kept the default settings – meaning I appended instead of overwrote the existing backup (this gave me a backup done on 11-11 and another done on 12-14). Instead of using Enterprise Manager’s restore command, I did a restore using a sql script that did not account for the appended backup (as I said, I’m an idiot). Instead, the new database was created from the original backup, dated 11-11. When we started using the new database on December 15 there was a one month gap in the activity (11-11 to 12-15). This morning, when I discovered the problem, I created a new database with the restore command - this time I used the 12-14 backup. My challenge is to identify activity in my production database from 12-15 to the present, and update my new database (created from the 12-14 backup) with this information, thereby eliminating the one-month gap while accounting for all records added or modified since 12-15. Is this possible, or have I screwed the pooch?
December 23, 2004 at 6:38 am
You might be able to use a tool like Red-Gate's SQL data compare to see the differences and script the ones you need to change.
December 23, 2004 at 8:21 am
You might want to first figure out the missing records (11-11 to 12-15) and get that data into the final database.
Then do the comparison.
-SQLBill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply