Home Forums SQL Server 2016 SQL Server 2016 - Administration Need Tutorial on Differential Backup RE: Need Tutorial on Differential Backup

  • February 27, 2018 at 1:02 am

    #1981238

    Jeff Moden - Monday, February 26, 2018 4:07 PM

    Seggerman-675349 - Monday, February 26, 2018 1:58 PM

    yes, that is what I needed - thanks folks

    Not quite.  It's a good example of the 3 types of backups but you need to write it as dynamic SQL so that you can change the file names over time.

    No you don't.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass