Home Forums SQL Server 2005 SQL Server 2005 General Discussion Can we take a transaction log backup in simple recovery model? RE: Can we take a transaction log backup in simple recovery model?
Ken Simmons
SSCertifiable
Points: 7822
More actions
April 3, 2009 at 9:53 pm
#971955
Transaction Log backups are only supported using the Full and Bulk-Logged recovery models because the Simple recovery model truncates the transaction log on checkpoint (when the data is written to disk) and marks the space as available for reuse.