Unable to create restore plan due to break in LSN chain
Recently I have faced with the same issue. I have googled for a while and found that this is a problem in the Microsoft products. I wrote the article according to this error message, so you can find more information there.
Disclaimer: I am the Marketing Manager for Pranas.NET, maker of the Sql Backup and FTP tool promoted in that article.
So, to solve this issue and restore your database to point-in-time use T-SQL commands:
Restore your last full backup
RESTORE DATABASE your_database FROM DISK = 'd:/full' WITH NORECOVERY, REPLACE
Restore your last differential backup
RESTORE DATABASE your_database FROM DISK = 'd:/diff' WITH NORECOVERY
And restore your transaction log backups, when you will restore the last transaction log backup point the time you need to restore your database
RESTORE LOG your_database FROM DISK = 'd:/log1' WITH NORECOVERY
RESTORE LOG your_database FROM DISK = 'd:/log2' WITH STOPAT = '2016-01-05 13:29:59.000', RECOVERY
Which SP of SQL Server 2012 did you use? This is a known issue with SQL Server 2012 SP2.
The information for "Restore to:" is empty, which was supposed to show the timelines. To work around this issue:
- Use SQL 2014 SSMS
- Use T-SQL