John Lowther looks at Moving Dynamics GP databases to a new SQL Server in his new Microsoft Dynamics GP DBA column.
Moving Dynamics GP databases to a new SQL Server
SQL & DataInstall, Upgrade & Admin
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.