AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        

Home » AyaNova v3 & v4 » AyaNova Support » Technical » Firebird Server related » Cannot Backup using Firebird Batch File

Cannot Backup using Firebird Batch File Expand / Collapse
Author
Message
Posted 6/18/2007 5:03:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 10/17/2008 8:59:57 PM
Posts: 7, Visits: 12
After following the steps on the Manual and pointing the file to the right path I cannot backup the database, I get the following error


C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>networkfirebirdsnapshot.ba
t

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>REM BEGIN SCRIPT

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>REM *** Create the backups
 folder if it doesn't already exist:

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>IF NOT EXIST E:\Backup\Aya
Nova MKDIR E:\Backup\AyaNova

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>REM *** Delete the oldest
copy and shuffle each existing copy to next position

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>REM *** This will produce
a harmless error at first until all 10 copies exist

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>REM *** error will not aff
ect backup

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>del "E:\Backup\AyaNova\AYA
NOVA10.FBK"
Could Not Find E:\Backup\AyaNova\AYANOVA10.FBK

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>ren "E:\Backup\AyaNova\AYA
NOVA09.FBK" AYANOVA10.FBK
The system cannot find the file specified.

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>ren "E:\Backup\AyaNova\AYA
NOVA08.FBK" AYANOVA09.FBK
The system cannot find the file specified.

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>ren "E:\Backup\AyaNova\AYA
NOVA07.FBK" AYANOVA08.FBK
The system cannot find the file specified.

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>ren "E:\Backup\AyaNova\AYA
NOVA06.FBK" AYANOVA07.FBK
The system cannot find the file specified.

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>ren "E:\Backup\AyaNova\AYA
NOVA05.FBK" AYANOVA06.FBK
The system cannot find the file specified.

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>ren "E:\Backup\AyaNova\AYA
NOVA04.FBK" AYANOVA05.FBK
The system cannot find the file specified.

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>ren "E:\Backup\AyaNova\AYA
NOVA03.FBK" AYANOVA04.FBK
The system cannot find the file specified.

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>ren "E:\Backup\AyaNova\AYA
NOVA02.FBK" AYANOVA03.FBK
The system cannot find the file specified.

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>ren "E:\Backup\AyaNova\AYA
NOVA.FBK" AYANOVA02.FBK
The system cannot find the file specified.

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>REM *** Perform a Firebird
 backup with verification

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>"C:\Program Files\Firebird
\Firebird_1_5\bin\gbak" -b -v -t -user SYSDBA -password "m0mentum" E:\Company Pr
ivate Folder\AyaNova\AYANOVA.FDB E:\Backup\AYANOVA.FBK
gbak: ERROR: unavailable database
gbak: Exiting before completion due to errors

C:\Program Files\Ground Zero Tech-Works Inc\AyaNova 3>REM END SCRIPT

Post #3244
Posted 6/18/2007 5:13:36 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: 11/29/2008 4:41:18 PM
Posts: 1,865, Visits: 4,323
Hi

I will point you towards the topic http://forum.ayanova.com/Topic1084-90-1.aspx regarding the error "gbak: ERROR: unavailable database"

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3247
Posted 6/18/2007 5:53:24 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: 11/29/2008 4:41:18 PM
Posts: 1,865, Visits: 4,323
Hi again

Check your networkFirebirdsnapshot.bat file - the command line where it identifies where to back up the AYANOVA.FDB database from E:\Company Private Folder\AyaNova\AYANOVA.FDB - confirm that this is where the AYANOVA.FDB actually is.

Also, you will need to edit the line

C:\Program Files\Firebird\Firebird_1_5\bin\gbak" -b -v -t -user SYSDBA -password "m0mentum" E:\Company Private Folder\AyaNova\AYANOVA.FDB E:\Backup\AYANOVA.FBK

as it needs quotation marks around the path "E:\Company Private Folder\AyaNova\AYANOVA.FDB" - because there is a break between Company and Private and the command won't understand that is part of the path

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3249
Posted 6/18/2007 6:26:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 10/17/2008 8:59:57 PM
Posts: 7, Visits: 12
Well I followed the Manual that says copy and paste from the Ayanova Config and that is how it is with the spaces. I also try manually the DOS mode E:\Compan~1\Ayanova\ayanova.fdb and still didn't work. I will check the quotation but I just copied and pasted from the error message, so I know it has the quotation marks and everything.
Post #3252
Posted 6/19/2007 8:30:11 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: 11/29/2008 4:41:18 PM
Posts: 1,865, Visits: 4,323
The manual section and the sample networkFirebirdsnapshot.bat show as an example that the AyaNova database would be located in C:\Data\AyaNova\AYANOVA.FDB - there is no break in any of the words, and therefore would not require quotation marks.

Whereas the path E:\Company Private Folder\AyaNova\AYANOVA.FDB does have a break in the path name, and therefore requires quotation marks, as does "C:\Program Files\Firebird\Firebird_1_5\bin\gbak" as shown in the example networkFirebirdsnapshot.bat file (break between Program and Files)

If you continue to experience an issue after editing the batch file as stated, do zip up and attach a copy of your networkFirebirdsnapshot.bat file. Do post back that this now works.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3254
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AyaNova Sales & Support

Permissions Expand / Collapse

All times are GMT -8:00, Time now is 7:36am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.094. 13 queries. Compression Disabled.