Backup SQL Database using SMO - Can't find Backup
ok, I am having some problems with SMO.
1. I have followed the instructions here to add the references (connectionInfo, Management.Sdk.Sfc, Smo, SqlEnum)
2. I have added to my form the following
using Microsoft.SqlServer.Manage
using Microsoft.SqlServer.Manage
My code is as follows
The error is : The type or namespace name 'Backup' could not be found (are you missing a using directive or an assembly reference?)
Why is it not locating Backup? I am using VS2010 and SQL Server 2008 R2
I was following this code
1. I have followed the instructions here to add the references (connectionInfo, Management.Sdk.Sfc, Smo, SqlEnum)
2. I have added to my form the following
using Microsoft.SqlServer.Manage
using Microsoft.SqlServer.Manage
My code is as follows
Server srv = new Server("servername\\databasename");
Backup bkpDBFull = new Backup(); //Namespace name 'Backup' could not be found error.
The error is : The type or namespace name 'Backup' could not be found (are you missing a using directive or an assembly reference?)
Why is it not locating Backup? I am using VS2010 and SQL Server 2008 R2
I was following this code
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Add a reference from the same folder as the others: SmoExtended.dll
Info found on: http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.backup.aspx
Info found on: http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.backup.aspx
Premium Content
You need an Expert Office subscription to comment.Start Free Trial