|
Backup for SQL Express or SQL Server
| • | You must use Microsoft SQL server approved backup and restore utilities only. |
| • | And you ONLY ever backup to a device the backup file that the SQL approved backup utility creates - you NEVER EVER directly backup or access in any way either the .MDF or the .LDF file of the SQL database - doing so can cause corruption of your database. |
Microsoft provides SQL Server Management Studio Express which can be used for backup and restore of a SQL Express database. Refer to Microsoft website to download and for instructions on use. Example location may be http://msdn.microsoft.com/vstudio/express/sql/
MS SQL Server Management Studio (installed with SQL Server 2005 and higher)
| • | You can not copy the SQL database files to a backup device, nor directly restore those files - it will more than likely result in corruption. |
| • | It is recommended to test your backup of your SQL database by restoring it and confirming it restores correctly. |
| • | It is recommended that you backup using the Simple Recovery Mode when using SQL Service Management Studio or SQL Service Management Studio Express so that you back up both the main database file MDF as well as the transaction log file LDF. And you should set up a regular database maintenance of shrink etc to maintain the size of the transaction log file. |
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 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, to restore just right-click on Databases and select Restore Database... and it will lead you through selecting the backup file to restore etc. |
Situation 2: Server has no previous AyaNova installation or SQL configuration:
| • | 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 configure this server to access 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, otherwise perform Step #7 of the SQL network configuration steps to configure networked computers. |
|