• 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...