Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
After deletion of table data , how can free space from data base
shantanu
Member Posts: 1
After deletion of table data , how can free space from data base
0
Answers
If you are using NAV native database the only way is to make a backup and restore into new, smaller database file.
If you are on SQL you can use DBCC SHRINKFILE command, or DBCC SHRINKDATABASE, or shrink the database or individual files from SQL Server Management Studio: righ-click your database, select Task -> Shrink -> Database or File
Shrinking individual fiules will give you better control of the process.
Just remember that shrinking is very time consuming process and it ruins internal indexes structure - so it is highly recomended to run index optimisation after the database or individual files have been shrunk.
In my experience it is also quicker to execuite shrink in small steps, say 1GB size. Running 20 steps shrinking the database file by 1GB each time is quicker that shrinking it by 20GB in one go.
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03