Here’s a quicky, while it’s on my mind. You don’t even have to call me the next day.
I needed to migrate the ConfigMgr database from an over-utilized SQL server to a dedicated SQL server for performance reasons. I came across this article describing the steps to take and, though it speaks specifically to SQL Server 2005 and SCCM 2007, the steps are essentially the same.
Click HEEEEEEERE to go THEEEEERRRE.
Please, for the love of everything above or below ground, test this process first.