Users came to me recently with a corrupted database after server crash. They have a full backup from a 3rd party backup software, and transaction log backups from a native SQL maintenance plan. Is it possible to restore this database to point in time before the server crash using these backup files from different sources? I tried the following:
Recover database from full backup with norecovery.
Recover trn file that is earlier than the full backup, SQL complaints about the time discrepancy...LSN... (I was excited as SQL at least recognize something here).
Recover trn made after full backup was made, SQL complaints about the backup sources.
users are in a bad situation as they stand to lose 3 days of data...
Thanks for your help.