Dear Concern
I m using Navision SQL database.My DB size is more than 80GB.I want to optimized the DB.If I'll optimize DB, then what will happen to my DB?I'll face any problem after Optimizing DB?
SQL DB needs maintenance - it means regular re-indexing (defragmenting), SIFT tables maintenance, statistics updates etc. It is not just about "press a button"... And one question - what do you expect from the "optimization"?
Comments
sorry I didnt understand what do u mean by maintanance pla?
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
I only want to know that what'll happen to DB when I opimized DB? What r benefits and disadvantages?
http://microsoft-dynamics-nav.blogspot. ... ion%20Slow
Anything more let me know