2005: using SMO

[R.A.M.]

Hello,
I am learning SQL Server 2005. I would like to write a procedure
making database backup using SMO. According to my book I should write
such code:

using Microsoft.SqlSe rver.Management .SMO;
public static void MakeBackup()
{
Server server = new Server("localho st");
Backup backup = new Backup();
backup.Action = BackupActionTyp e.Database;
backup.BackupSe tName = "Backup copy";
backup.BackupSe tDescription = "Backup copy";
backup.Database = "DemoSQLServer" ;
backup.Devices. AddDevice("C:\\ DemoSQLServer.b ak",
DeviceType.File );
backup.SqlBacku p(server);
}

The code cannot be compiled because of error:
The type or namespace name 'Management' does not exist in the
namespace 'Microsoft.SqlS erver'.
Please help to correct the problem - I cannot find proper name of SMO
namespace. Is the code OK?
Thank you very much
/RAM/

[R.A.M.]

I tried adding references to Microsoft.SqlSe rver.Connection Info and
Microsoft.SqlSe rver.Smo - and I could build assembly. But then I
cannot create assembly in SQL Server:

"An exception occured while executing a Transact statement or batch
(Microsoft.SqlS erver.Express.C onnectionInfo).
Assembly 'microsoft.sqls erver.smo, version=9.0.242 .0, culture=neutral ,
publictoken=898 45dcd8080cc91.' was not found in the SQL catalog.
(Microsoft SQL Server, Error: 6503)"

Could you help me to solve it...

[Erland Sommarskog]

R.A.M. (r_********@poc zta.onet.pl) writes:

I tried adding references to Microsoft.SqlSe rver.Connection Info and
Microsoft.SqlSe rver.Smo - and I could build assembly. But then I
cannot create assembly in SQL Server:

"An exception occured while executing a Transact statement or batch
(Microsoft.SqlS erver.Express.C onnectionInfo).
Assembly 'microsoft.sqls erver.smo, version=9.0.242 .0, culture=neutral ,
publictoken=898 45dcd8080cc91.' was not found in the SQL catalog.
(Microsoft SQL Server, Error: 6503)"

Could you help me to solve it...

There is a smaller set of .Net Fx assemblies that are loaded by default
in SQL Server. Apparently Microsoft.SqlSe rver.Smo is not one of them.
You could create an assembly in your database for the DLL with CREATE
ASSEMBLY, but I suspect that there is a reason why this DLL is not
loaded. I don't think the intention is that SMO is to be called from
within SQL Server. (But I have stayed away from SMO, so I don't really
know for sure.)
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx