Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 stackoverflow.com Jan 21 '12 at 12:35

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

add comment

1 Answer

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
add comment

Your Answer

 
discard

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