https://msdn.microsoft.com/en-us/library/ms177425.aspx SQL 2016 da gelen yenilik Piecemeal Restores (SQL Server) Cideo: https://www.youtube.com/watch?v=VuUAHI10o4E Another alternative is to use third party tools, such as Red Gate SQL Backup, Quest LiteSpeed, or Idera SQL Safe, which all allow you to perform object level restores using native SQL backups Red Gate's Hyperbac RedGateSQLBackup QuestLiteSpeed IderaSQLSafe Quests Litespeed You can also try some of the 3rd party tools that allow you to attach database backups and work with them as with live databases. You can try SQL Virtual Restore from Red Gate or ApexSQL Restore from ApexSQL or SQL Virtual Database from Idera. All of these are commercial tools but you can find fully functional trials to get the job done. Additional benefit of all of these is that they require very little additional space unlike standard backup restore.
