how to take database backup

[Abhijit Taur]

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

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

Abhijit Taur wrote:

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

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

Arne

[=?Utf-8?B?TW9ydGVuIFdlbm5ldmlrIFtDIyBNVlBd?=]

"Abhijit Taur" wrote:

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

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]