Cannot find type Microsoft.SqlServer.Management.Smo.Backup

Posted by Barac in SQL Server on Aug 14th, 2018 | 0 comments

In one of my previous posts, I show you how to use PowerShell to manage your SQL Server database backups and how to install the SQL Server PowerShell module.

To be able to manage SQL Server Database Backups you will need to load Microsoft.SqlServer.SmoExtended assembly.

If not you can end up with the following error.

PS>TerminatingError(New-Object): “Cannot find type [Microsoft.SqlServer.Management.Smo.Backup]: verify that the assembly containing this type is loaded.”
new-object : Cannot find type [Microsoft.SqlServer.Management.Smo.Backup]: verify that the assembly containing this type is loaded.

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoExtended") | out-null

On the following post, you can read more about how to Backup SQL Server database with the Powershell script, and about some other asemblies you may want to use, such as

# Import SQL server objects
Write-Output ((Get-Date -Format g) + " - Init MS SMO")
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | Out-Null
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoExtended") | Out-Null
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.ConnectionInfo") | Out-Null
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoEnum") | Out-Null

As well if you want you can download full Powershell script with use example how to Backup all user databases to Azure Storage.

Download source:

https://gallery.technet.microsoft.com/Use-PowerShell-to-Backup-3bb0a397

Description:
This PowerShell script can be invoked remotely from another PC through the command line, with PowerShell or executed remotely through task scheduler adding parameters – instance name, backup destination path, excluded databases list, Azure storage name, log file path.

About Me

My name is Zoran, currently living in Auckland, New Zealand. I am a data specialist with more than 15 years of hands-on experience in database administration and optimisation. I am also, Certified Microsoft Trainer (MCT) and Microsoft Certified Solutions Expert (MCSE) with a Master‘s degree in Information Technology. Sharing knowledge and contributing to the SQL Server community is my passion. I am also an organiser of the Auckland SQL User Meetup Group. As well I am active blogger and speaker at different SQL events such as SQL Saturdays, Meetups etc.

PowerShell / SQL Server Backup / Cannot find type Microsoft.SqlServer.Management.Smo.Backup

Similar Posts:

Leave a Reply Cancel reply

About Me

Email Subscription

Index Usage Report

Auckland SQL Group

MSDN PROFILE

Archives

SQL SERVER UPDATES

Recent Posts

Tag Cloud