Skip to main content

New answers tagged

6 votes

Restoring a broken SQL Server database - combining old DB+TL backup with new

The answer to your question is No. You cannot bring another transaction log backup(from a restored database) and restore with your current backup set. Why: Due to Log Sequence Numbers will not match. ...
SqlWorldWide's user avatar
  • 13.5k
1 vote

Database cannot be opened. It is in the middle of a restore

You need the additional command: RESTORE DATABASE test WITH RECOVERY; It appears that RECOVERY is ignored in the RESTORE LOG command, and it needs an additional command to confirm that the restore ...
comment-answers's user avatar

Top 50 recent answers are included