Troubleshooting: Getting an empty database list or database are not listing while creating SQL server backup
The occurrence of an empty database list is often attributed to the user authenticated to the SQL instance lacking the necessary permissions.
To address this issue, follow these steps to ensure the user has appropriate permissions:
1. Verify User Existence in SQL Server Logins:
- Open SQL Management Studio.
- Navigate to Security -> Logins.
- Double-click the account used for SQL instance authentication.
- If Windows authentication is used, verify the user account under which the "BDRSuite_Delegation_Service" service is running.
2. Grant 'sysadmin' Permission:
- Within the account properties, navigate to Server Roles.
- Confirm whether the 'sysadmin' role is enabled for the account.
- If not enabled, enable the 'sysadmin' role.
3. Map User to All Databases:
- Proceed to User Mapping in the left panel.
- Ensure that the user account is mapped to all databases.
- If not mapped, proceed to map it accordingly.
4. Finalize Changes:
- After enabling permissions or making any modifications, click the "OK" button to save changes.
- Close the properties window.
By following these steps, users can rectify the issue of encountering an empty database list on the Create Backup page by ensuring that the authenticated SQL instance user possesses the requisite permissions. If still the error persists contact BDRSuite support at vembu-support@vembu.com
Related Articles
Configuring MS SQL Database Backup
Configuring Microsoft SQL Database Backup ensures the reliable protection of your SQL databases, safeguarding critical data and ensuring business continuity. With customizable backup schedules, retention policies, and flexible recovery options, this ...
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. ...
Quick Start Guide for Microsoft SQL Server 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 ...
Getting Started with BDRSuite
The BDRSuite Getting Started Guide provides a comprehensive walkthrough of the entire backup and recovery setup process. Covering all BDRSuite modules, this guide helps users configure, manage, and optimize their data protection environment. It ...
Configuring MySQL Database Backup
Configuring MySQL Database Backup provides a reliable solution for protecting your MySQL databases, ensuring the safety of critical data and uninterrupted operations. With customizable backup schedules, retention policies, and flexible recovery ...