Troubleshooting: Getting an empty database list or database are not listing while creating SQL server backup

Troubleshooting: Getting an empty database list or database are not listing while creating SQL server backup

KB ID: 115908
Cause:
The occurrence of an empty database list is often attributed to the user authenticated to the SQL instance lacking the necessary permissions.
Solution:
To address this issue, follow these steps to ensure the user has appropriate permissions:
1. Verify User Existence in SQL Server Logins:
  1. Open SQL Management Studio.
  2. Navigate to Security -> Logins.
  3. Double-click the account used for SQL instance authentication.
  4. If Windows authentication is used, verify the user account under which the "BDRSuite_Delegation_Service" service is running.
2. Grant 'sysadmin' Permission:
  1. Within the account properties, navigate to Server Roles.
  2. Confirm whether the 'sysadmin' role is enabled for the account.
  3. If not enabled, enable the 'sysadmin' role.
3. Map User to All Databases:
  1. Proceed to User Mapping in the left panel.
  2. Ensure that the user account is mapped to all databases.
  3. If not mapped, proceed to map it accordingly.
4. Finalize Changes:
  1. After enabling permissions or making any modifications, click the "OK" button to save changes.
  2. 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

    • 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. ...

    • Troubleshooting Database/Instance Connection Issues

      KB ID: 231001 Summary: Error code 231001 indicates a connection issue between the Database/Instance and the backup server. This critical error message reads, "Unable to establish the connection between the Database/Instance and the backup server." ...

    • Error While Dumping MS SQL Backup Data in the Client

      KB ID: 115082 Error: Dumping MS SQL backup data fails at the BDRSuite client. Scenarios: The above error occurs at the BDRSuite client machine in the following scenarios: Cause 1: MS SQL database(s) configured for backup is set to offline. Solution: ...

    • MSSQL Backup Failure: SQL Writer Failed

      KB ID: 113 Problem: When attempting to perform an MSSQL backup, users may encounter a failure with the error message "SQL Writer Failed." Cause: The "SQL Writer Failed" error can occur to various reasons, including: 1. VSS (Volume Shadow Copy ...

    • Step-by-Step Guide: Restoring a Specific SQL Database from Image Backup for MS SQL Database Recovery

      KB ID: 62 The need arises to restore a specific SQL Database from an Image Backup, specifically focusing on MS SQL Database recovery. Solution: Follow the steps below for the MS SQL DB Recovery: Step 1: Mount Vembu Virtual Drive and attach the VHD ...