<div>
<div class="content wysiwyg-content">
Hi Experts, <br />
Very quick question, if I had one full MS SQL backup and multiple differential would I only restore the latest differential?<br />
<br />
For Example<br />
<br />
Full-Backup-MSSQL.bak <br />
Backup-MSSQL_diff1.bak <br />
Backup-MSSQL_diff2.bak<br />
Backup-MSSQL_diff3.bak &nbsp;<br />
<br />
Restore <br />
Full-Backup-MSSQL.bak<br />
Backup-MSSQL_diff3.bak<br />
<br />
Would this give me a complete backup? or would I need to restore all of the diff files?<br />
<br />
Thanks <br />
John
</div>
</div>


Hi Experts, 
Very quick question, if I had one full MS SQL backup and multiple differential would I only restore the latest differential?

For Example

Full-Backup-MSSQL.bak 
Backup-MSSQL_diff1.bak 
Backup-MSSQL_diff2.bak
Backup-MSSQL_diff3.bak  

Restore 
Full-Backup-MSSQL.bak
Backup-MSSQL_diff3.bak

Would this give me a complete backup? or would I need to restore all of the diff files?

Thanks 
John

MS SQL Restore with multiple diffs..

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.