Scheduled Backup Maintenance Plans SQL Server 2014

  • Please note that my Scheduled Backup Maintenance Plans on sql server 2014 indicates success but there is no backup file.Always On availability is disabled.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • Are you sure someone didn't remove or move the file?

  • MaintPlans are tough to troubleshoot when they don't work, never proper err logging. For something as important as backups I'd switch to the well vetted backup database command in a job..
    Put index/stat maintenance in Maintplans who cares about those when they don't work... j.k.
    Best,
    ChrisBecker.blog

    Chris Becker bcsdata.net

  • This was removed by the editor as SPAM

  • Hi,
    What is the output file saying my brother?Did this job ran before?

  • kapfundestanley - Monday, August 6, 2018 10:53 AM

    Please note that my Scheduled Backup Maintenance Plans on sql server 2014 indicates success but there is no backup file.Always On availability is disabled.

    Check the log files for the maintenance plan if you didn't disable those.
    Also check the backupset table in msdb to check if backups have been taken.

    Sue

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply