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>Search


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:  119 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.