• GRussell31 (7/16/2010)


    We have a slightly more complicated scenario...

    Our production database is backed up up using a 3rd party system which does not appear in the msdb tables, on top of that the log files are backed up every 15 minutes.

    Is it possible to use this approach (but introducing a SQL backup to the steps) to backup and restore the database without the backup truncating the logs?

    The database is unfortunately SQL 2000 but running in SQL 7 compatibility mode.

    Thanks...

    Where do they store backup info? You just use the same concept and change code to accommodate the scenario. The script operates entirely on backup only. Nothing to do with [backup truncating the logs?]