Skip to end of metadata
Go to start of metadata

Symptoms

The following error appears when taking a backup of Microsoft SQL Server database(s).

One or more selected databases is not valid or is no longer accessible.

What's going on?

This error appears when one or more databases selected for backup has been moved, renamed, deleted, or is otherwise inaccessible. A backup cannot be taken of a database that cannot be accessed.

Resolution

Remove the inaccessible database from the list of databases to be backed up.

In most cases, this error appears after a database has been deliberately removed or renamed. It must also be removed from the list of databases to be backed up.

  • Refresh the list of databases using the Refresh button at the top of the Backup What section.
    • ZCB will check SQL Server for databases that do exist. Any that are inaccessible will be removed from the backup set.
  • Save your backup set.