I have received an error when I try to restore a CaseWare Time Backup (Backup File Damaged), how do I resolve this?
NOTE: The below recommendations must be cleared and researched by your System Administrator to determine their implications to prevent any data loss or system issues. CQS will not be held liable for any loss of data or system instability.
The following are causes of CaseWare Time backup corruptions:
- When a backup is made when users are logged in
- Abrupt server shutdown - Usually a result of power outages or deliberate shutdowns while the database (program) is in use
- When the CaseWare Time Practice File is too large due to it containing older backups (such as SQLBackup.dat)
- Malware infection
- When the user does not have permissions to the data path or the path in which the backup will be saved in
- Hardware failures – These are the most common causes of damaged backups and are the result of computer hardware defects from hardware manufacturers or inadequate hardware maintenance.
Troubleshooting a damaged CaseWare Time Backup
NOTE: Please seek your IT Administrator’s assistance in determining the root cause of the issue.
- Check the logical and physical integrity of all the objects in the specific SQL database
Run the following SQL query on the concerned CaseWare Time database - DBCC CHECKDB
Click here for more information on running a SQL Query
Use SQL Server Repair kit to repair a corrupt SQL databases.
Click here to download the SQL Server Repair kit
- Run a disk error check to find any inconsistencies on the Hard Disk/Drive
- Right Click on the concerned Hard Disk/Drive
- Then select Properties | Tools
- Under the error checking section, click the Check button
- Click here for steps on how to check your hard disk for errors in Windows 7
- Use a 3rd party application to repair corrupt hard disk sectors and\or partitions
- Click here to download the application
- Optimize and defragment Hard Disk/Drive
- Right click on the concerned Hard Disk/Drive
- Select Properties | Tools
- Under the Optimize and defragment drive section click the Optimize button
- Click the Analyze and Optimize respectively to perform their said functions
- Click here for more information on how to Defragment and Optimize Drives
The following are preventative measures one can take to minimize CaseWare Time backup corruptions:
- Ensure that all the users are logged out of CaseWare Time, TaxWare and SecWare when creating a program backup
- Clean up the CaseWare Time practice folder – Contact BackOffice Support for assistance with this
- General Hard Drive Maintenance
- Check for errors and bad sectors
- Clean up the hard drive (Uninstall any software and delete any temporary files that are no longer in use)
- Create regular disk backups
- Defragment the hard disk
- After creating a backup, navigate to the backup location to verify that the backup size is reasonable, based on your practice SQL database size. Corrupt Backups are generally very small in size compared to your actual SQL database – Ask your IT administrator to verify this
Types of Backups:
If you have an integrated practice, ensure that backups are made of all the programs (i.e. CaseWare Time, TaxWare and SecWare). Please note that a CaseWare Time backup does not automatically backup TaxWare and/or SecWare
- Program backups
- SQL databases backups using SQL Management Studio. Click here for guidance.
- Copy the .mdf and .ldf files located in the SQL Server Data folder to a secure location.
- Ensure all users are logged out of all the programs (CaseWare Time,TaxWare and SecWare)
- Stop the SQL services. Click here for guidance.
- Copy the SQL Server Data folder on your server to a safe location.
- The Data folder can be found at one of the following locations
- C:\Program Files\Microsoft SQL Server\SQL Instance name \MSSQL
- C:\Program Files(x86)\Microsoft SQL Server\SQL Instance name \MSSQL
- Start the SQL services after successfully copying the said folder to a different location.
(Popularity = 13/100, Rating = 0.0/5)