Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 278 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
What size can our Database Grow to?
JimFranklin
Member Posts: 2
We are a retail company and we use Financials 2.60E which has been heavily bespoked to our quirky retail business (golf retail and we have our own managed stores and also franchise stores).
Our database is currently at 75gig, and we have a limit of 128gig on the licence. (we were originally told that 64gb was the limit, but when we reached that, microsoft cut us a new licence).
Restoring the database, which we carry out every week onto a backup server, from the FBK files frequently fails to complete. our NSC believes it may be because we are running out of space in the DB.
Some tables are huge,
our Item Ledger Entry table is over 10million records and stands at 25gb and the G/L is over 35million records and is 19gb.
The question?
How big can we get our licence up to? Microsoft and our NSC have no answer for us. Remember we were told 64 at one time, and 32 before that.
Anyone have any ideas? or do you know someone with a bigger db licence?
Thanks.
Jim
Our database is currently at 75gig, and we have a limit of 128gig on the licence. (we were originally told that 64gb was the limit, but when we reached that, microsoft cut us a new licence).
Restoring the database, which we carry out every week onto a backup server, from the FBK files frequently fails to complete. our NSC believes it may be because we are running out of space in the DB.
Some tables are huge,
our Item Ledger Entry table is over 10million records and stands at 25gb and the G/L is over 35million records and is 19gb.
The question?
How big can we get our licence up to? Microsoft and our NSC have no answer for us. Remember we were told 64 at one time, and 32 before that.
Anyone have any ideas? or do you know someone with a bigger db licence?
Thanks.
Jim
I've got wide staring eyes,
and a strong urge to fly,
but I've got nowhere to fly to
and a strong urge to fly,
but I've got nowhere to fly to
0
Comments
http://www.mibuso.com/forum/viewtopic.p ... abase+size
But, whatever they say, Microsoft should have an answer!
If it was hard to write, it should be hard to understand."
As I understand it, the current limit is 128GB for native Navision databases. As I understand it, you could have a larger database if you changed over to the SQL option.
It just might be worth testing to see if the restore fails if you try to restore the database into a more recent set of Navision executables (Say 3.70). I don't know if it will help, but it is certainly something that I would try out (On a test server!).
"A soul in tension is learning to fly.
Condition grounded, but determined to try."
Lead Consultant
Theta