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

  • Hi

    This is not new to SQL2005.....

    Easy way to do a Differential Backup..

    1. Right click on you DB in SSMS

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

    3. In the Backup Type select 1) Full or 2)Differential.

    4. Configure rest of the settings like file location etc....

    You can also do this in SSIS using a Backup Database Task Step.

    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