Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Defragging the server
JamieBrown
Member Posts: 107
Hi guys,
Our Navision (native) database server is extremely fragmented. Is there any steps I should take prior to running the defrag?
i.e. stopping the Database service, stopping DD or NAS?
In case it matters, we're runnign a raid 1+0 environment.
Many thanks in advance.
Jamie
Our Navision (native) database server is extremely fragmented. Is there any steps I should take prior to running the defrag?
i.e. stopping the Database service, stopping DD or NAS?
In case it matters, we're runnign a raid 1+0 environment.
Many thanks in advance.
Jamie
0
Comments
Make a backup
Stop All Navision Services if you can do it.
Matteo
I wonder how the disks where the db is located can become fragmented? I hope you are not using the same disks for fileserver purposes.
But if you have to defrag the disks, i strongly recommend to create a backup with the Navision client, stop the server and move the db files to other disks.
After defragmentation has ended move the db files back to their original disks.
Alex
Apart from BAS (html files) and backup *.fbk files the only other file on the logical drive is the fdb. (We've recently moved the path of the fbk files to a N.A.S)
The drive is 97% Fragmented! (I've never seen anything like it!)
If I try and defragment the drive now (using the standard Windows 2003 Server util) it errors, saying unable to complete. (All services were stopped).
Is this because we hadn't moved the fdb to another location?
Does anyone actually know 100% that a 1+0 raid array can be defragmented? - I'll google it....
thanks
Jamie
If you want, you can try the server defrag tool from http://www.oo-software.com.
I have made very good experiences with this tool and when I remeber correct can you get a working trial.
Regarding the Windows Defrag tool - it seems that there is still a service running which access or which try to access the drive with the database.
Regards
Kappe
Kappe