Can anyone please help me. How can you backup your database from within your application.
Backup
Collapse
X
-
It depends on what kind of database it is.
If its MS Access you should be able to use the File System Object to just copy the .mdb file to a new location.
If it is DB2, Oracle, SQL Server, etc you would have to do something different, and would likely want to either set up a routine within the database system itself (a stored procedure) that would copy your tables to a different server, or something within your application that would call a stored procedure to copy the tables. (This also requires that you have a back up server running DB2, Oracle, SQL server, etc) for it to be a true back up anyway. -
Comment