Data Backup

Spectrum || Backup

In the case, if the user wishes to format his system and henceforth requires to take backup of his software data to avoid the chances of losing the same, following steps can be taken up. A pre- requisite to this process is to close the Software on all the systems including the server. Following this, a folder is required to be created, where the data taken from the software can be saved before formatting the system. Once the Backup process is completely done and data is saved to the newly created folder, a copy of this folder should be made at a different location to be on a safer side.


Steps to Back up through Software:

Open Spectrum Software:


  • Go to Utility (at the left bottom) → Database UtilityBackup and Restore (excluding TDS). 

            
  • A Warning message to take TDS back up separately is displayed on the screen, please click on OK and proceed to take the back up of software excluding TDS.


  • Click on “Complete Backup” option and select the location where the folder is created to take the back up of the software. Name the back up file and Click on “Save” and wait for the Process completion message to appear.




This will create a Zip file back up of Spectrum software excluding TDS.


Similarly, take the back up of TDS software also as per the below given steps:


  • Go to Utility Database UtilityBackup and Restore (Only TDS).




  • Click on “Complete Back up” option and select the location where the folder is created to take the back up of the software. For TDS, there is no need to name the back up file as it would take its own name with its own format. Click on “Proceed” and wait for the Process completion message, to appear.




Manual Process for Back-up:
  1. Go to C Drive, Copy “KDK Data” folder and “Data” Folder from "C:\MySQL” and paste it to the folder created for data back up.
  2. A Separate back up for TDS as suggested above is also required for manual process.

TDS data is available in Microsoft SQL Server folder. The location of the folder is as follows:


Go to Windows Start  Run  → Type Services.msc


Under Services   Check the Service “SQL Server (KDKSQL8)




Here KDKSQL8 is the Default instance used for the database of TDS software.

  • Right Click on the Service and go to Properties.
  • To identify the location of folder "Microsoft SQL Server" you may route to the path specified under "Path to Executable".
  • Once the location is known, Stop the Services of SQL Server (KDKSQL8) and then copy the folder from the said location to the folder created for Back up. 


NOTE: - In case if there are multiple SQL services running as SQL Server (KDKSQL), SQL Server (KDKSQL1) or so on...
Stop the Services for all the instances and then try to copy the Microsoft SQL Server folder as any running instance would interrupt from copying the folder.

  • Apart from these folders, the Software creates some Recovery / Schedule Recovery files at location “C:\Windows” with. kbt and. kbu extensions. Copy these files to the folder created for back up.




This Completes the Back up Process. 



Steps to do Back up for LAN System


If system on LAN is to be formatted, since all the data would be available on the MAIN System, only the files like XML and FVU generated on the Particular LAN system would be available at “C:\KDK Data”.


Before Formatting the LAN system, you can copy this folder.


The process is same for Other products as well.

    • Related Articles

    • eXBace || Data back up and Data restore

      Whenever the user wants to format the system or change his system to other, there would be requirement to take proper data backup of the software so that the data is not lost. eXBace SAAS: Please note that you cannot take data backup of Exbace SAAS ...
    • Backup Restore - Through software

      If client has taken the data backup through software then regarding data restore please follow the steps below: For Data Restore in Spectrum (Excluding TDS): Open Spectrum Software and navigate to Utility → Database Utility → Backup & Restore ...
    • Spectrum || Schedule Backup

      Here are clearer step-by-step instructions for setting up daily backups for Spectrum and its modules, excluding TDS, along with configuring backup reminders for TDS: Daily Backup for Spectrum (Excluding TDS): Launch the Spectrum software. Click on ...
    • Income Tax || Custom Backup

      To take backup of any particular clients please open the spectrum module like Income Tax, TDS and then go to its Tools Menu >> Database Utility >> Custom backup. Now, Select the check box in front of the client for whom you wish to take backup then ...
    • Spectrum || Password Protection

      Password Protection for the software The software provides facility to set password for secure login in Spectrum application. This would help any unauthorized person in accessing the software and its data. Software also has a feature of Individual ...