we have a SharePoint 2010 production farm consists of 2 servers 1 server(App+ WFE) and 1 DB(sQL2008) server .
we would like to move the existing Databases from old server to new database server(Later decomission the old DB server)
As part of this, DB team has done backup and restore of all DBS( content DBS, config Db and service application DBS) to new server. Now I want to point the sharepoint farm to new database server which means detach all the existing DBS old server and point the databases to new server.
Could you please help advise the steps to peform to achieve this. Thanks in advance
Thanks for that. I have already gone through that article.I cannot use this  guide using SQL alias  procedure as we are going to decomission the existing server . please suggest if it works or any alternate approach
https://www.katprotech.com/pdf/MigrateSqlServertoanotherServer.pdf
Here is a pretty straightforward user guide on doing so.
