tag:blogger.com,1999:blog-5285970135510371565.post5222711520031104253..comments2024-03-23T07:53:50.523-04:00Comments on The Dynamics GP Blogster: Why shouldn't I shrink my Microsoft Dynamics GP databases?Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5285970135510371565.post-70375994230392598022011-02-15T16:14:10.420-05:002011-02-15T16:14:10.420-05:00@Anonymous:
I am not sure I agree with you, especi...@Anonymous:<br />I am not sure I agree with you, especially when Paul Randall, the lead developer responsible for the SQL Server storage engine says it's bad. Shrinking a database should only be considered when large amounts of data have been removed from the company database, which is rarely the case with GP databases anyways. If your log files are expanding out of control, maybe it's time to focus your attention on preventing this from happen by focusing on your backup strategy and your auto-growth settings.<br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-91862565635566898632011-02-15T16:07:21.930-05:002011-02-15T16:07:21.930-05:00@Anonymous:
I take great pride in my blog and its ...@Anonymous:<br />I take great pride in my blog and its content. Could you please point out the broken links specifically? I have tried clicking on all 3 pictures and have not found any issues with them. If you are referring to a diffent article, could you please point out the specific article?<br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-33123650258684121972011-02-15T14:04:07.838-05:002011-02-15T14:04:07.838-05:00Although your theroy is correct, there is nothing ...Although your theroy is correct, there is nothing wrong with a shrink database command after you run your backups. If it creates fragmentation then write the simple defragmentation code to fix the indexes. The reality is the log file will continue to grow in size until it is shrunk, taking up vital space on a server possibly causing it to ultimately fail.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-73255899305823789442011-02-15T13:59:09.425-05:002011-02-15T13:59:09.425-05:00Your blog has all sorts of broken links which is t...Your blog has all sorts of broken links which is the examples that you give references to. You might want to look into it.Anonymousnoreply@blogger.com