Backup & Restore > If using the network Firebird Server configuration > Restoring for AyaNova network Firebird Server configuration

The restore steps you perform depend on what the situation is - whether you are just restoring the AyaNova database, or whether you are restoring to a new computer (i.e. moving to a new computer or hard drive, or the original has been replaced)

Situation #1: The AyaNova program is still installed, the network Firebird server is installed, but an issue with the database requires restoring from backup:

1.Make sure no one is accessing the AyaNova database (via any AyaNova program or directly)

2.Make sure the Generator is shut down (if installed)

3.Make sure AyaNova Data Portal is shut down (if installed)

4.Shut down the Firebird services (Control Panel -> Firebird Server Manager -> Stop)

5.Rename the existing database file to AYANOVA.FDB.BAD

a.Never ever restore overtop of an existing AYANOVA.FDB database file.

6.Start the Firebird services (Control Panel -> Firebird Server Manager -> Start)

7.Restore the snapshot of the database – the AYANOVA.FBK file using the following:

a.Open a command window and move to the Firebird program bin folder C:\Program Files\Firebird\Firebird_2_1\bin

b.Extract the AyaNova database file from this restored file using similar to this command line substituting as needed the password, the snapshot file location and file name, and the location to restore the AyaNova database file to: (note enter this all on one line and do not copy – it must be manually typed)

gbak -c -v -user SYSDBA -password "masterkey" C:\Data\AyaNova\BACKUPS\AYANOVA.FBK C:\Data\AyaNova\AYANOVA.FDB

8.Check that the AYANOVA.FDB file is restored

9.Log in via the AyaNova program and confirm successful

Situation #2: Server has no previous AyaNova installation or network Firebird configuration

1.Perform the steps 1 through 5 only of Network Firebird Server configuration

2.Log in to the trial AyaNova database and ensure program installation successful

3.Close out of the trial AyaNova database

4.Shut down the Firebird services (Control Panel -> Firebird Server Manager -> Stop)

5.Rename the existing trial AyaNova database to AYANOVA.FDB.TRIAL

•Because you never ever restore overtop of an existing database file

6.Start the Firebird services again (Control Panel -> Firebird Server Manager ) and make sure is running

7.Restore using snapshot of your licensed database – the AYANOVA.FBK file by the following:

a.Open a command window and move to the Firebird program bin folder C:\Program Files\Firebird\Firebird_2_1\bin

b.Extract the AyaNova database file from this restored file using similar to this command line substituting as needed the password, the snapshot file location and filename, and the location to restore the AyaNova database file to: (note enter this all on one line and do not copy – it must be manually typed)

gbak -c -v -user SYSDBA -password "masterkey" C:\Data\AyaNova\BACKUPS\AYANOVA.FBK C:\Data\AyaNova\AYANOVA.FDB

8.Check that the AYANOVA.FDB file is restored

9.Now perform Step #6 of of Network Firebird Server configuration steps to configure this server to access this newly restored database via the AyaNova program

10. If there are networked computers that were previously connected, you can just replace their config.txt file, otherwise perform Step #7 of Network Firebird Server configuration steps to configure networked computers.