Share
Reportgood day all, i need some help. my client upgraded his rms sql to 2019 and the system is running slow. the server alone has the 2019 . is there a way to downgrade it back to 2008r2?
You’re offline. This is a read only version of the page.
410
good day all, i need some help. my client upgraded his rms sql to 2019 and the system is running slow. the server alone has the 2019 . is there a way to downgrade it back to 2008r2?
I generally will not upgrade sql instances and will create a new instance and restore a backup to that. With that being said there is no way to restore a database from a newer version of sql to even one version behind it. If you are dead set on doing that you can script out the database and then run the scripts to recreate it but that is not something I would even consider doing.
I've run RMS with sql 2019 and before that 2017 and so on with no issues. Are you patched to 2.0.2023? If not I would start there and then I would work on optimizing sql and troubleshooting from there. Is SQL running on its own dedicated server/ computer? Does the operating system have at least 8GB of RAM? The sql buffer cache in sql express can only use 1GB, but I usually set the max memory to 2-4GB depending on the system. How large is your database and how many clients are accessing it? You may want to try setting up a new sql developer instance and if that performs better then go ahead and purchase a sql standard server/ cal or core license. Do not use sql dev in production or that can cost you greatly in an audit.
Hi Alani
With GP Power Tools, you could code this very easily.
Regards
David
Hello,
There are a few ways to do it as part of a query, but they are all pretty terrible - mysql pivot is really, really not the right tool to do the job.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (