Recently I had to move all databases including the content database in a MOSS 2007 farm from one SQL server to another. I tried few methods and found the following steps are the easiest: [Assumption: All databases in the farm are on one SQL server and...

Run the following script in the content database: SELECT o.[Name] AS 'DatabaseName' , Instance.[Name] AS 'DatabaseInstance' , [Server].[Name] AS 'DatabaseServer' FROM Objects AS o INNER JOIN classes c on c.id = o.classid LEFT JOIN Objects...