No one can help you if you do not post details of your problem along with screen shots
When I tried to open my business, it came up with the same error message as the bloke above. It also changed my business name. See image.
ok
I am facing the same problem.
What did you do before this happened?
More information is required as there are several reasons with different implications of why this may happen.
1 Like
I downloaded a newer version of Manager.
Then upon trying to open the backup file.
It gave the message of This business database is not valid.
1 Like
Thanks.
I am starting the process of updating my software as I am currently running an old version V21.8.53 I have this version installed on my live windows 7 laptop and also on another laptop runing windows 10. I have just made a backup on my windows 7 (live) laptop on flashdrive and im trying to Add that business/backup to my windows 10 laptop, the business is in my list of businesses but when I click on it to open it it displays a message box with my business name and âThis business database is not validâ and not a SQlite database.
This is really strange because I am able to open a backup dated 2021-08-25 on exactly the same manager version?
Any help would be appreciated.
@itmoto, your situation is not quite clear. Please answer these questions:
- Are you still running v21.8.53 on both machines? Or are you running the new version on both machines?
- You say the business is in your list of businesses. On which machine?
- If you are referring to the business being in the list on the Windows 10 machine, was it there previously? Or did you just import it for the first time?
- Are you sure you actually imported the backup to the Windows 10 machine?
My suspicion, based on what you have shared so far, is that you have an old version of the database on the Windows 10 machine from before the change to the SQLite data structure. And you are trying to open it with an application version that no longer contains the conversion script.
The best way to do what you described is to first update both machines to the latest version. Only then, make a backup on the Windows 7 machine, selecting the flash drive as the backup location. Connect the flash drive to the Windows 10 machine and import the new backup, which will be distinguishable because its name includes todayâs date. After verifying everything is satisfactory, remove obsolete versions of the business from the Windows 10 machine and rename the business (if desired) by removing the date.
Thanks @Tut
I am running V21.8.53 on both windows 7 and windows 10 laptops.
when I import a backup taken from my windows 7 laptop to the windows 10 laptop it imports OK and adds it to my list of business, when I click on the business to open it thats when it flags the Database not valid message.
Itâs really strange as I have already opened a backup in the past on a backup taken on the 25/08/2021 which was after I installed V21.8.53 on the windows 10 laptop.
This is how I test new versions on my spare W10 laptop before updating my W7 (live) laptop.
I do not wish to update both machines yet as I need to test it on the windows 10 laptop. I cant have my live W7 laptop disrupted as its in constant use and only make a change when everthing is running smoothly on the W10 machine.
I donât see the purpose of this. If you are trying to test whether the new Manager version runs successfully before updating your live machine, you need to test the new version. You already know your business is successfully opened and runs under v21.8.53. Why test that on an operating system you arenât going to use it under?
The error message you are getting is exactly what Manager displays when trying to open a business data file (or backup) last updated prior to v20.9.89. That is when the SQLite conversion script was removed from new versions. The date of your 25/08/2021 backup is no guarantee what version it was created under. Unless you have independent records of when you did your updates, I would disregard whatever experience you have with that file.
Meanwhile, have you tried making another backup and importing it onto the Windows 10 machine? Maybe you got a corrupted file.
I know I need to test the new version, I was trying to get my latest data on the W10 laptop, then I normally update that laptop to the latest version and compare against my W7 live laptop for any change in numbers. If they both agree I know I can test further by creating some purchases and sales and confirm my custom themes still work as expected and there are no nasty surprises.
If I were to update both I will have no benchmark to compare to. I would have thought thatâs how everyone would do it, no?
I name my manager file so it includes business name, the date of the backup and the version number so I can, if needed, roll back to a older version. I also keep a copy of the software download of that version.
Anyway, a breakthrough.
I tried two other flash drives that I use to backup my data and they thankfully import and open fine without the âdatabase is not validâ message box appearing.
I had several other backups from that flashdrive that would not open either going back to february this year, then files earlier than that would open fine.
That drive is now in lots of bits in the bin!
Im glad I had lots of spare drives as well as backups on line, they have all been tested and are fine.
As always @Tut thanks for your help.
With your more complete description of your update process, all makes sense. Thatâs a fine approach. You previously left out the part about updating the Windows 10 machine after verifying the backup.
Your flash drive experience illustrates a basic law lots of people overlook: all drives will eventually fail, no matter the technology.
Thanks @tut
I shall be testing my backups more often from now on as I had thought all backups would be fine, glad I used more than one drive now, can never be too careful!
1 Like
If you search the forum, people including myself explain the need for a so called 3.2.1 backup rule for any application, desktop or server. (Google on 321 rule).
I backup often in multiple ways, this is the first time I have experienced a corrupt file, I mean how often should you check all your backups work as they should? From todayâs experience itâs a lot more than I thought it was.
@itmoto, I think your backup plan is acceptable. Yes, a flash drive failed. But you had other backups, so no harm was done except the effort figuring out why your file wasnât recognized. Just make sure you replace the failed flash drive so you donât reduce your redundancy.
1 Like