Sql server few DB not backed up RRS feed

  • Question

  • We have backup job scheduled every night to take backup user and system databases and it's runs fine every night bit sometimes it shows backup job successfully runs but log shows that it has taken only one database backup out of 7 database (user and system DBs). Event viewer or sql server logs not showing any error and sql batch scheduler also not showing any failed backup or other errors but only shows job succeed.

    We are using cursor (FORWARD_ONLY) to read each database excluding Temp Db from system table and taking Backup and storing database to shared folder.

    Any thoughts?

    Wednesday, November 13, 2019 3:55 AM

All replies