1. Sql Express supports SMO?
2. If so How can I make a backup of a database programatically?
ThanksI found how do it. but still waiting for the other answers.
Its so easy, I love Microsoft Tools.
using Microsoft.SqlServer.Management.Smo;
namespace SMOTest
{
class Program
{
static void Main()
{
Server svr = new Server();
Backup bkp = new Backup();
bkp.Action = BackupActionType.Database;
bkp.Database = "AdventureWorks";
bkp.DeviceType = DeviceType.File;
bkp.Devices.Add(@."c:\SMOTest.bak");
bkp.SqlBackup(svr);
}
}
}
I am using the example code with minor modifications and can't get around the unable to connect error.... Has anyone run into this issue? I have tried everything I can think of at this point and it just won't connect to the local instance.
|||You do know that you can overload the Server instantiation to direct it to the server you want to connect to, don't you?
Example:
Dim srv As Server
srv = New Server("MyLapTop\Express")
In VB.Net you can also set the property in the ServerConnection object:
Dim srv As Server
Dim srvConn As ServerConnection
srv = New Server
srvConn = srv.ConnectionContext
srvConn.LoginSecure = True
srvConn.ServerInstance = "MyLapTop\Express"
Either one should work for you.
No comments:
Post a Comment