Tuesday, March 20, 2012

Backup databases programatically.

Hello

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);
}
}
}

|||SQL express does indeed support SMO.|||Thanks|||

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