Cannot Restore Backup (Sage)

Cannot Restore Backup (Sage)

Didn't find your answer?

Backup was done with version 7 now using version 11 trying to restore backup return error message "Error creating file C:\PROGRAM FILES\SAGE\ACCOUNTS\ACCDATA\TMAIL\TMAIL.MDB"

Then it will say backup restore unsuccessful. However, the company name will appear on the Tittle bar and a logon screen will come on. If I try to login it will return invalid password message.

Any help is appreciated.

Replies (20)

Please login or register to join the discussion.

avatar
By princeusus
20th Sep 2011 18:49

Operating system Windows XP

Thanks (0)
avatar
By johndon68
20th Sep 2011 19:14

Restore

If the file in the error message exists, try deleting it then restoring the backup again.

Invalid Password would suggest that the restore was not successful.

John

Thanks (0)
avatar
By User deleted
20th Sep 2011 20:25

Can version 11 read version 7?

I know periodically SAGE versions can't read earlier ones, for instance version 11 will have to be loaded into v12 and a new back up done before it can be loaded into v18!

Thanks (0)
avatar
By princeusus
20th Sep 2011 22:27

Thanks johndon68 but i cant open the backup at all. I tried using Explorer but it wont open, so please How can i delete the file? or Check if its in the backup? Although the message said "Error creating"

Thanks (0)
avatar
By princeusus
20th Sep 2011 22:46

Thanks Old Greying Accountant, let me try and load it in version 9 and see. Wish me luck.

Thanks (0)
avatar
By JKnight
20th Sep 2011 23:27

Johndon68's advice was to delete the TMAIL.MDB file (if it exists)  from the location given in your opening post, not from the Sage backup itself.

You will not be able to open the backup using Windows Explorer as it needs to be restored into Sage.

As I understand it, you should be able to restore a backup from v7 of Sage Line 50 in to all versions up to v13 (Sage 50 Accounts 2007). 

 

Thanks (0)
avatar
By spurs1952
22nd Sep 2011 12:20

sage

call sage help

Thanks (0)
Replying to FirstTab:
avatar
By johndon68
22nd Sep 2011 12:35

Sage

spurs1952 wrote:

call sage help

Sage don't support v11 any more, it was 'end of lifed' some time ago...

John

Thanks (0)
avatar
By Iveymj1
22nd Sep 2011 12:54

Sage Backup

From past experience you may need to restore the version 7 backup onto version 10. Then create a version 10 backup.

Restore the version 10 backup onto version 12 and create a version 12 backup.

A version 12 backup should then resotre onto any more recent versions of sage line 50.

I hope this helps.

Thanks (0)
Replying to P.J.and Co:
avatar
By johndon68
22nd Sep 2011 13:01

Sage Restore

Iveymj1 wrote:

From past experience you may need to restore the version 7 backup onto version 10. Then create a version 10 backup.

Restore the version 10 backup onto version 12 and create a version 12 backup.

But the OP is trying to restore in to v11, not v12 or later, a v7 backup should restore into v11 with no problems...

John

Thanks (0)
avatar
By RonParker
22nd Sep 2011 13:32

SAGE

Why not try this if all else fails.

From your current version of sage, produce an audit trail, then use the import facility to import the transactions

The result may not be pretty, but you will have the transactions in the G/L etc

Thanks (0)
Replying to brian.barrett:
avatar
By johndon68
22nd Sep 2011 13:38

Import Audit Trail

RonParker wrote:

Why not try this if all else fails.

From your current version of sage, produce an audit trail, then use the import facility to import the transactions

The result may not be pretty, but you will have the transactions in the G/L etc

Only problem with that is that the import/export routine ignores the following transactions:

Sales Receipt

Sales Discount

Purchase Payment

Purchase Discount

 

It might help at this point if the OP was to come back and say if deleting the file in question solved the problem... :)

John

Thanks (0)
avatar
By 0098087
22nd Sep 2011 14:10

Sage,,,shudder
 

Sage,,,shudder

 

Thanks (0)
avatar
By Iveymj1
22nd Sep 2011 14:44

My mistake

Sorry for mis reading the query but the approach will still work by creating a version 10 backup first.

From memory Sage made some major changes to the software structure in version 10, so to convert from any version pre version 10 to post version 10 you need to get a version 10 backup.

Thanks (0)
avatar
By colinhigginson
22nd Sep 2011 16:56

Iveymj1 is correct

You do indeed need to restore it into version 10, take a backup and then restore the version 10 data into Sage version 11.

I think it was something to do with the Report Designer changing file formats in version 10.

 

Thanks (0)
avatar
By johndon68
22nd Sep 2011 17:24

Restore v7 backup in to v11

A v7 backup can be restored directly into v11 (in fact you can go back to v5) and the data will be upgraded automatically.

Whilst there were changes to some stationery layouts that required the running of an additional utility called AddPurch (Which is detailed in the v11 documentation), this would not stop the restore of a v7 backup into v11 and would not produce the error that the OP reported.

John

Thanks (0)
avatar
By colinhigginson
22nd Sep 2011 17:27

Service Pack

I am sure that about that time there was a service pack on floppy disk which needs to have been loaded and applied to version 11.

I have had the same problem as the op and always found loading into version 10, then into 11 solved the problem.

Thanks (0)
avatar
By csvcsvcsv
22nd Sep 2011 18:43

csv 7 to 11 backup

Unfortunately Sage will only allow you to go back 3 years with previous backups of Sage

 

If you have a recent version - did you have an older version previously

If so after backing up your current version and making sure you have all of the codes and product keys - re-install your earlier version which may still be compatible with 2007

Alternatively get your client to give you log in rights to their computer so that you can open and use the sage 2007 on their computer.

 

Pulling off the reports you require and sending them to yourself.

 

 

Thanks (0)
Replying to petersaxton:
avatar
By johndon68
22nd Sep 2011 18:55

Restoring Backups

csvcsvcsv wrote:
Unfortunately Sage will only allow you to go back 3 years with previous backups of Sage

No they don't - v2011(17) can restore backups all the way to v11 (i.e. going back 6 years) and v2012(18) can restore backups back to v12, as I've mentioned, v11 can restore backups all the way back to v5...

csvcsvcsv wrote:
If so after backing up your current version and making sure you have all of the codes and product keys - re-install your earlier version which may still be compatible with 2007

Not sure I understand what v2007 has to do with it, the OP is going from v7 to v11...

John

Thanks (0)
avatar
By princeusus
26th Sep 2011 20:02

Thank you all,

Unfortunately, i tried restoring it in Version 7, 9, 10 & 11 all give same error message but some with a different file name.

Sage want me to pay ridiculous amount of money afterward they will tell me that Version is no more supported.

So as alternative, we setup again as at 1/1/11 and post the transactions again.

 

Thank you all for all the suggestions and support.#

I have to try and be online with accountingweb so i can assist others too when they are in need.

Thanks again.

Thanks (0)