Unsolved
1 Message
0
1017
Avamar backup SQL Server 2017 databases
Has anyone made backup SQL Server 2017 databases using Avamar? If so, please share your experience in the configuration because the standard (SMO, permissions for the System, and the SQL plugin) does not allow to make a copy of the databases using the SQL plugin. The same configuration for SQL 2016 works correctly.
Avery Lane
1 Message
0
July 31st, 2020 12:00
You need to upgrade Avamar to a version that has the SQL SMO package included. SQL Server 2016 SMO is installed via SQL Feature Pack or SQL Server Client Tools during install.
Beginning with SQL Server 2017 SMO is distributed as the Microsoft.SqlServer.SqlManagementObjects NuGet package to allow users to develop applications with SMO. This is a replacement for SharedManagementObjects.msi, which was previously released as part of the SQL Feature Pack for each release of SQL Server. Applications that use SMO should be updated to use the NuGet package instead and will be responsible for ensuring the binaries are installed with the application being developed.
Source: https://docs.microsoft.com/en-us/sql/relational-databases/server-management-objects-smo/installing-smo?view=sql-server-2017#smo-nuget-package