Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Hopefully you can help out on this as I may be up a creek!

I am working with a database using the FULL recovery model. The database has had nightly database backups but their transaction log has never been backed up (according to SQL Server Management Studio).

If I restore from one of the old database backups, would it be possible to take a backup of the current transaction log and bring the restored database forward to a point in time prior to a terrible transaction that got pushed through?

share|improve this question

migrated from Jan 21 '12 at 12:35

This question came from our site for professional and enthusiast programmers.

up vote 1 down vote accepted

If the log has never been backed up, then it could have been shrunk or truncated at some point. otherwise, it would have just grown. It's also possible that it has changed to SIMPLE and back to FULL.

You have one option: try it...

share|improve this answer
+1 to you for easy rep earned. I was in a state of panic but fortunately this transaction log had never been shrunk, truncated, and the database had never been switched to SIMPLE. Success. – retailevolved Dec 13 '10 at 20:52

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.