Error: Backup Failed

SOLVED

I am getting an error when I am trying to backup Sage:

Backup failed: Could not create a temporary file used for backup.

I've run the verify Advanced Database Check. No errors found

As far back as a few months ago, the error log reports that the database was not shut down normally. "Restoring possible half-written data pages from the double write"

Before that, "Error in my_thread_global_end(): 2 threads didn't exit)

From there, it seems that increasingly InnoDB is having difficulty with log sequence numbers.

I'm worried now that the database is corrupt?

any advice or help appreciated.

  • 0

    The "thread" error is normal, the "double write" could be serious if accompanied another error by: "InnoDB: Warning: purge reached the head of the history list". The ibdata file could bloat to be a gig+ in size. Reply back with the size of the ibdata,

  • 0 in reply to GwG

    I have a file called ibdata1 - Size 21,504KB

  • 0 in reply to SimplyChristine

    Corruption is not the problem.... try creating a folder c:\simdata, move your data to the new folder then backup... if that fails... try the sample company

  • 0 in reply to GwG
    verified answer

    I've managed to backup the file, but found the answer here: sagecity.na.sage.com/.../backup-tips-and-tricks.aspx

    <quote>

    Why are my backups increasing exponentially in size every time I create one? I’m also finding from time to time, the program locks up or freezes and the backup isn’t successfully created.(NOTE: This issue occurs for users who are using Simply Accounting 2008 and later)

    I usually find the reason for this exponential growth in size is because the backups are being saved in the SAJ folder. Starting in Simply Accounting 2008, the database was changed from Microsoft Access to MySQL. With this change, the database in Simply Accounting is made up of a Sai file and a SAJ folder. Saving the backups in the SAJ folder will cause the exponential growth in size and in some cases cause the program to lock up or freeze. This isn’t a recommended place to save backups as I’ve found in some instances, saving backups here for long periods of time can cause damage to the database itself.

    How do you confirm if the backups are being saved in the SAJ folder? Click on “File/Backup” in Simply Accounting’s home screen and double check in the “Location” field that it isn’t being saved in the SAJ folder. If it is, click on the “browse” button and choose a different folder other than the SAJ folder to save the backup to. Once you do this, then try creating a backup. If you find this doesn’t work, click on “File/Properties” in the home screen of Simply Accounting. Take note of the “Company File” (the name of your database) and the “Location”. Close the program, then use Windows Explorer or the My Computer icon (Computer icon in Windows Vista and Windows 7), to browse to the location of your database. Double click the SAJ folder and remove ONLY THE BACKUPS in this folder. Once this is completed, re-open your database and try creating a backup again outside of the SAJ folder.

    </quote>

  • 0 in reply to SimplyChristine

    The persons who built a backup utility into Sage that could back up into the place it was backing up from, should be soundly thrashed.  Then, they should be given the opportunity in turn, to thrash the QA people who signed off on it.