Post reply

How to setup incremental backup?

  • February 3, 2009 at 10:19 am

    #218224

    Hi,

    I am learning incremental backup setup in sql server 2000. Please help with notes on how to set up incremental backup in sql server 2000.

  • February 3, 2009 at 10:30 am

    #937335

    Best place is to look on this site and then look on MS and google it

  • February 3, 2009 at 10:30 am

    #937336

    Best place to start is BOL (Books Online). It can provide you much of the information you are looking for regarding backups.

  • February 3, 2009 at 10:35 am

    #937346

    Thanks,

    But there are no topics for incremental backup in Books online. I need to learn how to setup incremental bakps that runs every 4 hours and how can i get it to restore during a crash.

    Any help or documents highly appreciated..

  • February 3, 2009 at 10:41 am

    #937349

    This link has code for any type of backup.

    Backup SQL Server Databases

    http://weblogs.sqlteam.com/tarad/archive/2008/08/19/Backup-SQL-Server-Databases.aspx

  • February 3, 2009 at 11:08 am

    #937372

    Sql Student (2/3/2009)

    Thanks,

    But there are no topics for incremental backup in Books online. I need to learn how to setup incremental bakps that runs every 4 hours and how can i get it to restore during a crash.

    Any help or documents highly appreciated..

    Actually there is, they are called transaction log backups, or if you are using the simple recovery model, then it would be your differential backups.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply