On 5-4-2014 03:56, Andrew Gable wrote: > Just wondering how or if it is possible to do a snapshot back up of a > Firebird database from VB6? > > I can get the location of the database but whenever I try to copy the > file to my back up drive with in > VB6 I get a error 70 Permission denied. > > I Do not want to use any external applications to back up the database > > Can someone help or point me in the right direction?
Copying the database file when it is in use is not a good idea, you can get a copy that is in an inconsistent state. The copy mechanism that you use probably tries to get exclusive access to the file, which doesn't work as Firebird is also using the file. I'd suggest you use the service API to create a gbak or nbackup backup of Firebird; this requires no external applications (except of course the Firebird server itself). The other option (if you are using Firebird 2.0 or higher) is to use ALTER DATABASE BEGIN BACKUP, copy the file (which probably still requires a copy method that doesn't require exclusive access), and then when you are done ALTER DATABASE END BACKUP. See http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-ddl-database.html#langrefupd25-alter-db Mark -- Mark Rotteveel
