Hi Ravi,
You can Use SQLDMO.dll, which is shipped with SQLSERVER2000 and
write the Backup of DataBase Easily.
The following code is written in C# and Hope this maybe helpful to
You.
using SQLDMO;
//Necessary declarations
SQLServer2Class server = new SQLServer2Class();
Database2Class database=new Database2Class();
Backup2Class backup = new Backup2Class();
//Connect to server
server.LoginSecure = true;
server.Connect("localhost", "nanda", "sqladmin");
//Select database you want to backup
database.Name="Test";
backup.Database = database.Name;
//Specify the place where backup to be saved.
backup.Files = @"C:\mydb.bak";
//Effective backup of the database
backup.SQLBackup(server);
//Disconnect, don't forget it
server.DisConnect();
Response.Write("Backup Completed.");
Bye
--- In [email protected], [EMAIL PROTECTED] wrote:
> Hi,
>
> We have to implement Backup and Disaster Recovery for the data in
one of
> our .NET web application.
> The task is so complicated e are planning to go for a third party
tool and
> interface it with the application.
> if any one have done this before? please help me out for a solution.
>
>
>
> Best Regards
> Ravi Ramanujam
> VJIL Consulting Limited
> "Usha Kiran" 1-8-165,S.D.Road
> Secunderabad - 500 003,Andhra Pradesh.
> ( Office:+91-(40)-27810633 Ext:1043
> ) Mobile:+91-9885699132
> Mailto:[EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
>
> [Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
