Microsoft.sqlserver.management.smo.failedoperationexception: Backup Failed For Server '\\.\pipe\3f103e6e-3fd4-47\tsql\query'

I'm gonna get a backup with below method : void BackupDatabase(string sConnect, string dbName, string backUpPath) { using (SqlConnection cnn = new SqlConnection(sConnect))

Solution 1:

The error message is pretty much conclusive:

Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Is SMO installed correctly?

Are you running on a 64 bit system?

Have you installed the 2008 version of the SMO Components?

You can down the 64 bit version of SMO from here: Microsoft SQL Server 2008 Feature Pack, October 2008

Solution 2:

I had to install this package :

X64 Package (SQLServer2005_XMO_x64.msi) - 14675 KB

My problem was solved.