Q

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

Dig deeper on SQL Server Backup and Recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close