Home Forums SQL Server 2005 Backups How to Take Incremental Backup in sql server RE: How to Take Incremental Backup in sql server

  • Hi, not new....

    Using the GUI to do backup, or configure the backup task in SSIS, specify to do 1) Full 2)Differential Backup.....

    Short "how-to" - easy way...

    1. Right Click your db in SSMS

    2. Focus on "Tasks" -> "Backup"

    3. on the general screen, look for: "Backup Type"

    4. Select your backup type: Full or Differential etc....

    and the rest of the criteria and file locations you need to modify as you need it...

    Hope this helps....

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle