Backup SQL database

[rdnzl]

Hi!
In an Access adp file, it's possible to make backup of the SQL database. I would like to do the same from code (VBA/VB6). I've searched the MSDN (and Google), but I haven't found anything.
Anyone here that have a solution for this? (No, the FSO doesn't work either, because the db files are in use.)

TIA

 

[tlbroadbent]

From the main menu select Tools | Database Utilities | Backup. You'll be prompted for the name and location of the backup. This only backs up the server databse and objects. You'l need to copy the ADP file, to back it up.

You can also use the SQL Backup command. Th following link to the internet version of SQL BOL provides the complete syntax and examples.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ba-bz_35ww.asp

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[rdnzl]

But I would like to write the backup routine in VBA or VB6, is that possible?

 

[tlbroadbent]

Here is one way to perform the backup from VBA.\ using the SQL Backup command.

DoCmd.RunSQL ("backup database YourDatabase to disk='\\servername\sqlbackup\YourDatabase.BAK'&quot If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[rdnzl]

Thank you, I'll try that.