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

 

[Arne Vajhøj]

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/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

 

[Morten Wennevik [C# MVP]]

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 )

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