KB Issue
SQL Server Management Studio: doing A Log File backup; the Step failed.
Issue Details
While performing database LOG file backups, you may encounter the following error.
SSMS 3014
SQL Server Management Studio message 3014. The step failed
Recreate Issue
During the Log File Backup, an error will occur if the database Recovery Model is set to Simple.
Resolve Issue
Setting the Recovery Model to Full will resolve the issue and allow you to schedule backups to continue and complete successfully.
Right-click on the database
Choose [
Properties
]
Choose the [
Options
] from the left-side panel.
Recovery model: Choose [
Full
]
Next, click [
OK
]
The next Step is very important.
To complete the backup.
Expand [
SQL Server Agent
]
Expand [
Jobs
]
!IMPORTANT
Run the database backup first, as since you changed it from simple to full, a new backup is required.
Right-click the Database Backup.
Choose [
Start jobs at Step
].
? Next, back up the log files.
Right-click the Log Back.
Choose [
Start jobs at Step
]