CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

 CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:

  • SQL Server Management Studio message 3014. The step failed

    • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    7289
  • Date Created
    Saturday, January 17, 2026
  • Last Updated
    Saturday, January 17, 2026
  • This Article Has been Viewed
    0 times
  • Short Desc

    SQL Server Management Studio: doing A Log File backup; the step failed.
  • Article Details

    While performing database LOG file backups, you may encounter the following error.

     
    SQL Server Management Studio message 3014. The step failed
  • Recreate Issue

    During the Log File Backup, the 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 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]

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles