• farik013 - Wednesday, September 12, 2018 7:36 AM

    Hi. There is a lot of post about my question, but I have little different problem. We have an SQL Server 2008 R2. And full backup taken from SSMS 2017. When I want to restore it on SQL 2008, there is an error. But I can restore it on 2017. It was 2 weeks ago and I want to restore this backup and differential to it. It takes diff without problems, but only full backup give an error "restore headeronly is terminating abnormally 3013 read failure on backup device". Because only that day backup was take manually via SSMS 2017.

    You will not be able to restore a SQL Server 2008 R2 database to SQL Server 2008.  Although both are SQL Server 2008, the R2 version has a different disk structure than 2008.  You could think of SQL Server 2008 R2 as SQL Server 2010.
    The version of SSMS doesn't matter.