SQL Server Performance

Implementing Incremental Backup

Discussion in 'SQL Server DTS-Related Questions' started by sagarpbora, Apr 11, 2007.

  1. sagarpbora New Member

    Hi,

    I am working on one application, which retrieves data from multiple tables in the database and all the fields retrieved, are exported as an excel sheet. All the export functionality is done through DTS. And the data is retrieved using an SP.

    I am supposed to use an "incremental backup" approach here. Means, for the 1st scheduling of the package, all the database dump will be there in excel file. But, after that only fields that are updated/inserted are to be filled in the excel file. Each time, when the dump of the database is taken, the excel file is stored in an archive folder with Date and tiemstamp(e.g. TEST_11_04_2007_15_00_00.xls)

    e.g. For the first dump, I get 100 records from the database. Before next execution of the package, 10 rows get inserted and 1 row gets updated. So, on the second time execution of the package, I should populate the excel sheet with those 11 rows only, and not 110 records.

    I am not authorised to change the database schema.
    So, is there any approach to try out this?
  2. satya Moderator

    Why you want to reinvent the wheel?
    You can get such backup information from the system tables, having them sorted out will get you required information.
    If it is not the case, then you have to control the part of excel using macros.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page