On this page we can find the way to connect to our Microsoft SQL Server 2008 R2 and restoring our company database Backup to the "ocac" database from the installation CD or from our previous
backup that we have on our computer hard disk. By doing these following steps on our Main Computer or Server to restore the database already been prepared by OCI Systems Pte Ltd.
Click on the Windows Start-up Button and choose Microsoft SQL Server 2008 R2 node then Click on the SQL Server Management Studio.
We have to Click the drop down to browse for more to find our computer name.
Click on the Local Servers then click on the Database Engine.
After we select the server next type the Username and Password into appropriate text boxes on the Login Screen both as "ocac", then click Connect Button.
Now on Next window click the add button.
Important Note : If you are changing your server system or Recovering back your Server please use the latest database Backup that you copied from your existing Server or Main Computer and make sure you are not doing any data entry into your accounting system after you finished your last backup from the server. If you did some data entry after you finish your final backup you can not see those records in your new SQL Server Database after you Restore it, unless until if it is required only few entries in case of urgency. Also remember to re-key in these records to your new SQL Server Connected System.