Restore filegroup without log sequence number (LSN)



  • I have the following error:

    The roll forward start point is now at log sequence number (LSN) 5470633000000066000001. Additional roll forward past LSN 19429240000000043500001 is required to complete the restore sequence.

    Now I explain: I have a database in "restoring..." mode, because I applied a restore of files and filegroups, from a .bak file that I took in the past, but I do not have a transaction log file of the type .trn with the LSN 19429240000000043500001, to recover the database. What can I do to bring the database back online or return the restore process without losing the other ndf child data that was in the database?

    Image restoration process failed:
    Image restoration process failed



  • SQL Server will not give you a database where different parts of the data are from different points in time. If you restore a part of the database from an earlier point in time, then there are two scenarios:

    1. The filegroups affected by that restore has been read only since that backup was taken. SQL Server knows that no modifications could have been performed on the data that was restore and no subsequent log backups are required.

    2. The filegroups affected by that restore has not been read only since that backup was taken. SQL Server need an unbroken chain of log backups so it can re-do all the modifications on the restored data so it is up-to-date with the rest of the database. If you are missing any of those required log backups, then the filegroups affected by that restore will be "defunct" and will forever be a "dead" and inaccessible part of that database.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2