Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K 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
- 295 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
Full database, everytime i try to expand it
chrisxx83
Member Posts: 54
Hi
i have problem with my database. Everytime I try to expand it and open again, in one second it makes full again.
How can I check witch function makes that strange thing? (number of records in tables are correct)
i have problem with my database. Everytime I try to expand it and open again, in one second it makes full again.
How can I check witch function makes that strange thing? (number of records in tables are correct)
0
Comments
Could you put some more info on what version you are on. SQL or natvie db?
What steps do u take to expand the db?
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
NAV 5.0 SP1 PL, native
We crateded a copy of .fdb file and on our local computers problem still appear.
Steps:
1. We open the database
2. Expand it
3. Now database works quite fine ( we have some problems with keys in tables, but db size not increasing)
4. We close database
5. Open it again and get error about reaching space limit We work on local copies so all processes are stopped.
Thanks in advance for any help
Are you sure there aren't any processes that automatically start? Database does not expand by itself.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
You need to switch the DB to read only and create a full backup. Then upgrade your executable to a later version. Check Waldo's blog to see what version you can upgrade to. You will want to find a version that made changes to the Native client (fin.exe). Now restore the database.
The error you had most likely came from a network error of some kind, so you also need to do a complete check of the network and alook for bad network cars, switches or cables. Its very important that you get this bit sorted.
http://www.mibuso.com/forum/viewtopic.php?f=23&t=33802&hilit=expand+database+error
http://www.mibuso.com/forum/viewtopic.php?f=23&t=28872&hilit=expand+database+error
http://www.mibuso.com/forum/viewtopic.php?f=23&t=25330&hilit=expand+database+error
http://www.mibuso.com/forum/viewtopic.php?f=23&t=20222&hilit=expand+database+error