Skip to main content
Solved

Unable to see DB backups from Enterprise Manager or VBR when using Veeam's SQL plugin for SSMS


Forum|alt.badge.img+1

Unable to see DB backups from Enterprise Manager or VBR when using Veeam's SQL plugin for SSMS.

Not sure if this is by design to allow DBA full control of their backup and restore processes or I’m just missing something here.

 

Thanks again for all your inputs.

Best answer by spider32

Veeam replied back that this is by design. 

“The Veeam SQL Plugin is a Standalone product at the moment and has very limited functionality with Veeam Backup and Replication.

This is by design:

Only way to Browse the Backup and view the Restore points of the Backup is directly with the Veeam SQL Plugin again.”

 

Thanks again for your inputs.

 

View original
Did this topic help you find an answer to your question?

14 comments

Chris.Childerhose
Forum|alt.badge.img+21
  • Veeam Legend, Veeam Vanguard
  • 8401 comments
  • November 18, 2024

Check here for the requirements for the SQL Plugin to SSMS as you need at least 19.x - System Requirements - Veeam Plug-ins for Enterprise Applications


Forum|alt.badge.img+1
  • Author
  • Experienced User
  • 78 comments
  • November 18, 2024

Thanks for the link showing the System Requirements. The requirements are met. While looking at this, I also saw one issue, I don’t see the plugin in the SSMS toolbar. But no big deal, just need to make sure if the issue exists or by design. Thanks.

 


Chris.Childerhose
Forum|alt.badge.img+21
  • Veeam Legend, Veeam Vanguard
  • 8401 comments
  • November 18, 2024

There is an MSI file you run for the plugin to install it on the SQL Server so it shows in the toolbar of SSMS.  You will need to do that and it should then show.


Chris.Childerhose
Forum|alt.badge.img+21
  • Veeam Legend, Veeam Vanguard
  • 8401 comments
  • November 18, 2024

This link will help with location of the MSI - Installing Veeam Plug-in - Veeam Plug-ins for Enterprise Applications


Forum|alt.badge.img+1
  • Author
  • Experienced User
  • 78 comments
  • November 18, 2024

The plugin has been installed and tested as working for both full/log backups and restores using SSMS. For some reason, it does not show on the toolbar. Anyway, this is a minor issue.

The bigger issue is can we use VBR console or the Self-service portal with the SQL Veeam plugin? Thanks.

 

 

 


Chris.Childerhose
Forum|alt.badge.img+21
  • Veeam Legend, Veeam Vanguard
  • 8401 comments
  • November 18, 2024
spider32 wrote:

The plugin has been installed and tested as working for both full/log backups and restores using SSMS. For some reason, it does not show on the toolbar. Anyway, this is a minor issue.

The bigger issue is can we use VBR console or the Self-service portal with the SQL Veeam plugin? Thanks.

 

 

 

I am not sure if the plugin directly interacts with the Veeam VBR Console or not as I believe it was for dong backups in the SSMS console directly.  You can use VBR and the Self-Service console for SQL interactions.

 
 
 

Forum|alt.badge.img+1
  • Author
  • Experienced User
  • 78 comments
  • November 18, 2024

The screenshot from SSMS shows the tlog backup the was setup using Veeam’s plugin.

The screenshots of the VBR and Self-service portal do not show accessibility to these log backups.

 

 


Chris.Childerhose
Forum|alt.badge.img+21
  • Veeam Legend, Veeam Vanguard
  • 8401 comments
  • November 18, 2024

So there is a disconnect of some sort from VBR and the plugin.  Unsure as I don’t really use the plugin so I might suggest opening a support case if you need to get access back to those logs.


coolsport00
Forum|alt.badge.img+20
  • Veeam Legend
  • 4109 comments
  • November 18, 2024
spider32 wrote:

The plugin has been installed and tested as working for both full/log backups and restores using SSMS. For some reason, it does not show on the toolbar. Anyway, this is a minor issue.

The bigger issue is can we use VBR console or the Self-service portal with the SQL Veeam plugin? Thanks.

 

 

 

Hi ​@spider32 - the toolbar icon is not supported on your version of SMSS, according to the Sys Req’s:

SMSS Req’s For SQL Plugin

 

It looks like you’re using SMSS 20+.

Also, it looks like the EM Self Service Portal only supports vSphere VMs:
https://helpcenter.veeam.com/docs/backup/em/em_working_with_vsphere_portal.html?ver=120

For SQL Restores, according to the Plugin Guide, you need to either user the Restore (UI) Wizard or cmd line on the DB Server. If you want to restore SQL DB to another server, you have to run the Restore Wizard on that server.
https://helpcenter.veeam.com/docs/backup/plugins/mssql_db_restore.html?ver=120
https://helpcenter.veeam.com/docs/backup/plugins/mssql_db_restore_ui.html?ver=120

If you want more direct confirmation on both your questions, aside from the info I found in the User Guides, you can probably poke at the Veeam PMs on the Forums.

Hope that helps.


Forum|alt.badge.img+1
  • Author
  • Experienced User
  • 78 comments
  • November 18, 2024

Thanks for the input. Yes as of now, everything (DB backup and restores) is all done within the SSMS. Just really curious if this was part of the design. I will open a ticket. Appreciate much.


coolsport00
Forum|alt.badge.img+20
  • Veeam Legend
  • 4109 comments
  • November 18, 2024

Yeah...I think it is by design so as to keep the backup process with the DB, while utilizing Repository (backup storage) flexibility of VBR (i.e. immutability, etc).

Keep us posted what you find out.


Forum|alt.badge.img+1
  • Author
  • Experienced User
  • 78 comments
  • Answer
  • November 19, 2024

Veeam replied back that this is by design. 

“The Veeam SQL Plugin is a Standalone product at the moment and has very limited functionality with Veeam Backup and Replication.

This is by design:

Only way to Browse the Backup and view the Restore points of the Backup is directly with the Veeam SQL Plugin again.”

 

Thanks again for your inputs.

 


Chris.Childerhose
Forum|alt.badge.img+21
  • Veeam Legend, Veeam Vanguard
  • 8401 comments
  • November 19, 2024

Glad to hear they got back to you with an answer.  Nice to see what it is as I did not know this with the plugin myself.

 
 
 

coolsport00
Forum|alt.badge.img+20
  • Veeam Legend
  • 4109 comments
  • November 19, 2024

Yep, as I thought. Thanks for confirming ​@spider32