Error 701, "42000", [Microsoft]{ODBC SQL Driver][S

hvdhoeven

Not enough system memory available to execute this query.

I want to copy one company to 40 the same companies in one database (for educational use). First I backup company 1. Then I rename company 1 to company 2. I restore the backup of company 1. I rename (the new) company 1 to company 3. And so on till I have 5 companies, then I backup these 5, rename the existing 5 to 6-10 and restore the backup of 5. Then I make a backup 0f 10 and aftre that also of 20. At last I have 40 companies.

When restoring the backup of 1-20 in the database where I already have 21-40 I keep getting the error above. I've tried twice to restore the backup.

Can anybody explain this error and do you know the reason and solution?
Thanks for your help.

Hans van der Hoeven

Marije_Brummel

SQL keeps the companyname in the tabledefinition do renaming a company is very intensive.

Better is to prepare your database in the Native environment and then import the entire database into SQL Server.

DenSter

Try restoring 10 companies at a time, or increase the memory on the server.

hvdhoeven

Thanks!

Is there a max for a NAV-SQL Database? Can I put 40 Cronus companies into one database?

Marije_Brummel

No there is no official max.

One of my customers has over 1600 companies in one database but then management becomes a real challenge.

DenSter

Each restore operation is regarded by NAV as one transaction, and the more companies you include in each restore, the bigger the transaction. It appears that you have found the limit for number of Cronus companies .
<edit>per restore I mean, you could still repeat restoring 10 companies until you run out of space on the server. I hope you are saving each backup, so you can repeat this more easily</edit>