After performing a reinstall of my system, I'm trying to take a copy of a database using a SQL Azure Batch Backup tool. Also, I have SQL Server 2016 SP1 Express installed.
However, when I try to run the backup tool it tells me
Error message = Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified..
After some googling I found out that Microsoft.SqlServer.Smo is one of the SQL Server Management Objects. Fine. Understandably this wouldn't be installed with SQL Express. So can I install this on its own?
Apparently "If you want to ensure that SQL Server Management Objects is installed on a computer that will run your application, you can use the Shared Management Objects .msi in the SQL Server feature pack."
So I followed that link to a page which offers me 6 different .msi downloads, none of which have anything like "shared management objects" or "sql server feature pack" in the name.
Can anyone point me in the direction of an installer which will install these SQL Server Management Objects, compatible with SQL Server 2016 SP1 Express?
If you scroll down the download list, you will see more downloads and "ENU\x64\SharedManagementObjects.msi".