SQL databases move
Dears,
we are moving our SQL databases (Service Manager DB and ServiceManagement ) to another SQL server (hardware change) . Is there a correct process that we could follow?
Is it enough to backup the database, restore it on the new SQL server and then re-run the cireson setup to point at the new SQL server and restored database?
Are there any considerations prior to the actions?
thank you in advance
G.
Answers
Hi @George_Kouskouridas
No there shouldn't be anything else you need to do what you have highlighted sounds perfect and here is an example of someone else in the same shoes!
Let me know if you need anything else 😀
Thanks,
Shane.
@Shane_White
To move the ServiceManagement DB is easy to fix with the run of the Portal setup.
The ServiceManager DB is a beast of its own.
@George_Kouskouridas
You can probably use some of the setps in this guide below.
https://support.cireson.com/KnowledgeBase/View/1263#/