Notifications
Announcements
No record found.
Hi Friends,
*This post is locked for comments
This was a huge "NO-NO"! DBA's are taught to not shrink the SQL database because it can lead to very bad instability and data integrity problems,which is what you are having now. What you needed to do instead was run the maintenace wizard and focus on defragmenting indexes. Use Indexes to get around the performance bottlenecks that come with large databases.
We used to shrink databases back in the early 2000's when storage was very expensive, but there were always warnings and we worried when we did it. In today's time, this is not recommended because you will get all kinds of issues just as you are now.
You may be able to fix this issue through a painful process of replacing the forms or missing, unstable data but that will take a long time. Many people used to just restore a backup and then foward the new added information to the restored backup.
I'd say that you learned a good lesson about shrinking being bad, and that will save you a lot of work in the future.
hi Brandon
You mean to say shrinking should not be done at all, if we are running out of space say in Development or test box, i just did a shrinking in my local box, however i get the error Failed to create a session; confirm that the user has the proper privileges to log on to Microsoft Dynamics"" , when i try to sync.
But i can see proper data in all my masters forms.
Environment: Ax2012 R2
SQL : SQL server 2012
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
