No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>


To have a better experience, please upgrade your IE browser.


Performing the Transaction Log Backup for SQL Server Only Partially Succeeded

Publication Date:  2015-07-29 Views:  87 Downloads:  0
Issue Description
After the transaction log backup for SQL Server is performed, check the backup result and find that only partial backup is competed.

Handling Process
Set the recovery model of SQL Server for which the transaction log backup is to be performed to Full or Bulk-Logged.

For details on how to change the recovery model for SQL Server, refer to Configuring a Recovery Model for SQL Server(Download View).

Root Cause
The transaction log backup cannot be performed for SQL Server whose recovery model is Simple.