SQL Show (3/7/2013)
anthony.green (2/14/2013)
Highly risky move, should be backing up to individual files not one big file, as should anything happen to that 1 file you cannot restore to any of the subfiles contained within.Anthony Green, Could you please explain me? If 1 file corrupted, can not I restore 5th differential file?
No, because the scenario described there are multiple backups in a single file, corrupt the file and all backups are gone, not just one.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability