hi team, today i have restored my database with transaction log, but it gives me a error like
what might be the problem. i have planned for data mirroring
This error happens when Full back up is not restored before attempting to restore differential backup or full backup is restored with WITH RECOVERY option. Make sure database is not in operational conditional when differential backup is attempted to be restored. Also make sure that your log chain isn't broken.
E.g. If you have a full back up @ 6 AM and Log backups every 1 hour. say you are at 8 Am if you want to restore your backup at 8 then
RESTORE Full WITH NORECOVERY
RESTORE LOG WITH NORECOVERY (of 7AM)
RESTORE LOG WITH RECOVERY (of 8AM).