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. ...
Adding Microsoft SQL Server for Backup
MS SQL Server can be backed up using the BDRSuite Backup Server. You can simply add the MS SQL Host as a Data Source to the BDRSuite Backup Server and configure backups. Navigate to Data Sources tab and choose Add MS SQL Server. When a MS SQL Server ...
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 ...
Quick Start Guide for Microsoft SQL Backup & Recovery
About Microsoft SQL Backup & Recovery BDRSuite delivers data protection for Microsoft SQL Server, enabling full, differential, and transaction log backups for comprehensive database recovery options. It supports automated backup scheduling, ensuring ...