Restoring for AyaNova SQL configuration

<< Click to Display Table of Contents >>

Navigation:  Backup & Restore > If using the network SQL configuration >

Restoring for AyaNova SQL configuration

Restore for SQL Express or SQL Server


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 new hard drive, or the original has been replaced)


Situation #1: The AyaNova program is still installed on the server and so is SQL, but an issue with the database requires restoring from backup:


1. Restore the SQL database using the restore steps of your SQL approved backup program.


For example, if have used SQL Server Management Express for backup, you would delete the existing AyaNova database that has an issue with it (as never ever want to restore overtop of an existing), and then to restore just right-click on Databases and select Restore Database... and it will lead you through selecting the backup file to restore etc.  Refer to your SQL Express Help for steps.



Situation #2: Server has no previous AyaNova installation nor AyaNova database or SQL configuration:


1.Perform the steps 1 through 4 only of SQL network configuration - for SQL Express or SQL Server

ensure network TCPIP communication through your network

install stand-alone AyaNova trial to the server

install and configure SQL

set exceptions in server's firewall for SQL


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

3.Close out of the trial AyaNova database

4.Restore your SQL database as per your SQL approved backup program

5.Now perform Step #6 of of the SQL network configuration to set the config.txt file so connect to the SQL server accessing this newly restored  SQL database via the AyaNova program

6. If there are networked computers that were previously connected, you can just replace their config.txt file with the new config.txt file from the server, otherwise perform Step #7 of the SQL network configuration steps to configure networked computers.