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
-
Depends.
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.
Slawek Guzek - www.yitron.co.uk
Business Central, MS SQL Server, Wherescape RED;0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
