CSharp/C#, how to take database backup

by **Abhijit** » Sun, 07 Sep 2008 21:35:27 GMT

hi
i am using vb.net2005
i want to take daily backup from application
and attach that daily backup if any data loss

by **Arne Vajh** » Sun, 07 Sep 2008 22:50:09 GMT

Read http://msdn.microsoft.com/en-us/library/ms186865 (SQL.90).aspx
and http://msdn.microsoft.com/en-us/library/ms190372 (SQL.90).aspx, if
it is not clear then ask more specific.

Arne

by **TW9ydGVuIFdlbm5ldmlrIFtDIyBNVlBd** » Mon, 08 Sep 2008 13:48:08 GMT

You need to use Microsoft.SqlServer.Management objects

using System.Data.SqlClient;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;
...
using (SqlConnection conn = new SqlConnection(connString))
{
ServerConnection serverConnection = new ServerConnection(conn);
Server server = new Server(serverConnection);
Backup backup = new Backup();
backup.SqlBackup(server);
}

Translate to vb.net as necessary (PS you did as a C# group :P )

You will most likely have to set several properties on the Backup object
before calling SqlBackup, as well as subscribe to events.

--
Happy Coding!
Morten Wennevik [C# MVP]

CSharp/C#, how to take database backup

CSharp/C# >> how to take database backup

CSharp/C# >> how to take database backup

CSharp/C# >> RE: how to take database backup