We are running Sharepoint 2013 on a 1-tier farm setup. I need to change this to a 2-tier setup where the SQL Server 2012 with the DB will be located on its own server and Sharepoint 2013 will be located on the same server as it is now. Basically, I need to migrate the SQL DB from the 1-tier server to a new server and leave Sharepoint where it is.
Can you please aid with this. The web does not seem to have much instructions on Sharepoint 2013.
Thanks in advance