Unable to List Databases during Microsoft SQL Server Backup
KB ID: 110000
Case 1: Microsoft SQL Server services are not running properly.
Problem:
This error occurs when the system is unable to list databases. This issue may arise if the SQL Server service and its associated services are not running.
Solution:
To resolve this error, follow these steps to ensure that the necessary SQL Server services are running:
1. Check SQL Server Service: Verify that the SQL Server service is running. Navigate to the SQL Server service and ensure it is in the 'Running' state.
2. Verify Associated Services: Confirm that the following associated services are also running:
- SQL Server Analysis Services CEIP (MSSQLSERVER)
- SQL Server CEIP service (MSSQLSERVER)
- SQL Server Integration Services 13.0
- SQL Server Integration Services CEIP service 13.0
- SQL Server Reporting Services (MSSQLSERVER)
- SQL Server VSS Writer
- SQL Server Agent
3. Restart Services if Necessary: If any of the services are not running, restart them to ensure proper functionality.
4. Reattempt Database Listing: After ensuring that all required services are running, try listing the databases again. The issue should be resolved.
Case 2: User access details used to connect the SQL server instance while configure the backup doesn't have proper permission
Problem:
The user who can connect to the Microsoft SQL Server doesn't have proper permission to list the databases.
Solution:
Ensure that the ‘sysadmin’ permission is enabled for the user and attempt the backup process again.
By following these steps, you should successfully address this error by ensuring that the essential SQL Server services are running as required and necessary permissions are provided.
Related Articles
Microsoft SQL Server Recovery
Microsoft SQL Server Recovery can be performed directly from the BDRSuite Backup Server. The recovery can be performed at a granular level. . You can click on the Recovery tab in the BDRSuite Backup Servers home screen and select Restore Backup Data. ...
Microsoft SQL Server Recovery
Microsoft SQL Server Recovery can be performed directly from the BDRSuite Backup Server. The recovery can be performed at a granular level. . You can click on the Recovery tab in the BDRSuite Backup Servers home screen and select Restore Backup Data. ...
About BDRSuite for Microsoft SQL Server Backup
BDRSuite offers a comprehensive backup and disaster recovery solution tailored for Microsoft SQL Server, ensuring secure, efficient, and reliable protection of your SQL databases. Designed to meet the backup needs of small, medium, and enterprise ...
Microsoft SQL Server - Adding Data Source
The data sources tab will list the various environment that you can backup and by selecting which you can enter the host details that you like to backup will be added and then listed for you to proceed with the further configuration. Also, you can ...
Microsoft SQL Server Recovery: Granularly Recover Microsoft SQL Server from the entire VM backup
Microsoft SQL Server Recovery Microsoft SQL Server Recovery can be performed directly from the BDRSuite Backup Server. The recovery can be performed at a granular level. . You can click on the Recovery tab in the BDRSuite Backup Servers home screen ...