I had my principal database in a SQL server that was scheduled to back up at 9 AM and 3 PM. A second server contained these backups in case of failure. The main server went down yesterday at about 2 AM, and the most recent backup was at 3 PM the day before. I was able to recover from the backup on the backup server, but users began work without realizing that there were changes made between the last backup and the start of morning work that did not make it into the restored DB.
They're still working today, but I want to transfer the transactions made against the backup server to the original server, which I have now recovered. Is there a way to migrate the transactions made to the backup to the original server? There are lots of transactions that were made, and a mass insertion doesn't work because there are modifications, insertions, deletions, etc.