Incorporate intact transaction log
I have a SQL database that is being backed up nightly. The corresponding transaction log is not. I can restore the previous night's backup, but I need to incorporate the transaction log that is still intact.
As long as the database is set to FULL recovery or Bulk-Logged you will be able to issue a transaction log backup. To create a backup of the transaction log you can either use Enterprise Manager or you can issue the following command:
BACKUP LOG databasename TO DISK = 'C:\filename_LOG.bck'
Once you have the transaction log backed up you can then restore both your full backup and your transaction log backup.
Do you have comments on this Ask the Expert Q&A? Let us know.
This was first published in July 2005