Home Forums SQL Server 2012 SQL 2012 - General SQL2012SP1, simple recovery, transaction log full, can't add another, won't grow RE: SQL2012SP1, simple recovery, transaction log full, can't add another, won't grow

  • I've considered recreating the entire database, because I can successfully pull all the data out via Import/Export Wizard's SSIS. In fact I have a couple copies of the database data pulled out that way. However, there are timestamp fields involved, and I hate to lose all that data, and I know of no way to preserve all the timestamp field data.

    Also, I have multiple databases in this same situation.

    Really, I'd like to know how to solve the situation, in case it occurs on a production system.