Before attempting to move the databases associated with your SharePoint instance, make sure you backup your farm before continuing. For example, the following PowerShell script performs a full backup of the farm:
Backup-SPFarm -Directory c:\backuppath -BackupMethod Full
Depending on the size of the databases, this may take some time to complete.
One thing to check before starting the move is that the version of SQL is identical for both the source and target servers.
Once your happy that SharePoint has been backed up, the first thing to do is stop all SharePoint and Internet Information Services (IIS) services on the server that is running the Central Administration Web site. Do this by opening the Services snap-in from the Microsoft Management Console.
Continue reading