Hi Expert,
How will data mirror SQL Server Application from one server to another . How to check which server machine depended on this server and how will move it from sql server 2011 to sql server 2017 with all dependency, jobs, agents etc together
os windows server 2008 to win server 2016
Shree
November 13, 2020 at 10:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
November 13, 2020 at 11:18 pm
Hi Expert,
Any suggestions
Strongly suggest you get a copy of DBATools downloaded from the powershell gallery and start learning how that can help to elevate a lot of the pain when migrating. It will take care of nearly everything for you, copy your databases, logins, jobs etc
https://www.youtube.com/watch?v=Fraig15pwxE
https://dbatools.io/tag/migration/
As for knowing what is connecting to what, well thats where you should have proper technical documentation about what systems interact with which database/server.
Failing that you would schedule something like sp_whoisactive to be run every so often, (second/minute) to capture the connections or you put a login trigger on the system to log the application and system which is logging in.
And remember TEST TEST TEST
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply