NandaGopalreddy,

Thanks for the reply.

Two types of data: 
1. Physical files
2. database data(SQL server)


Following are the requirements in backup and recovery:

capability for separate physical storage of back-up
most recent back-up state to the point of system failure
updates to the data which are
Unable to be restored / rebuilt, and provide notification to an 
Administrator.
distributed repository with multi-site Service.
support caching of frequently and recently used Repository content 


Is there any third party API's to which i can interface the application
to get all the job done?
 
Regards
Ravi Ramanujam 
 

 




"nandagopalreddy" <[EMAIL PROTECTED]>
Sent by: [email protected]
06/15/2005 06:20 PM
Please respond to AspNetAnyQuestionIsOk
 
        To:     [email protected]
        cc: 
        Subject:        [AspNetAnyQuestionIsOk] Re: BackUp & Recovery


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



 





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



Reply via email to