Click here to Skip to main content
15,886,199 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how to code backup and recovery of database on 3-tier application design.
please help

[inserted from OP solution]
Function backup_database() As DataTable
            Dim dal As New csSQLDALVB
            Dim list As New List(Of csParameterListType)
            Return dal.executespreturndt("BackupD_mydatabase", list)
      End Function
      Function restore_database() As DataTable
            Dim dal As New Restore_database
            Dim list As New List(Of csParameterListType)
            Return dal._datatable("RESTORE_DATABASE", list)
      End Function
End Class


Yes m using sql server. this is my functions on business layer and on presentation i called it like this

Dim restore As New BACKUP_recovery
            restore.restore_database()


what must i do on the Sql server?
Posted
Updated 25-Aug-11 2:30am
v3

It depends on what your database is. For SQL Server, you can write BACKUP and RESTORE queries in T-SQL and call them from your VB.NET code using ADO.NET. Similar commands exist for Oracle and MySQL.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900