Hi Mike, I think I have used these instructions in the past: http://www.eggheadcafe.com/software/aspnet/30290259/moss-and-move-sql-databas.aspx
For this issue, please follow below steps to move all the content database. Step One: Backup the web application and check the database ====== 1.1 Start SharePoint 3.0 Central Administration and Click Operation Tab. 1.2 Click "Perform a Backup" under Backup and Restore. 1.3 Check the Farm to including all elements and make notes of all the configuration database and content database name. 1.4 Select "Continue to Backup Options" and select "Full" backup, type the file path for backup file location. 1.5 After finishes, check the file path for backup file location. Stop IIS here Step Two: Detach the Content Database ====== 2.1 Download and install the SQL client and the Sqlcmd utility. These tools are available in the latest feature pack for Microsoft SQL Server 2005. For more information about the feature pack for Microsoft SQL Server 2005, visit the following Microsoft Web site: -aa0a-b477ba72a9cb&DisplayLang=en> 2.2 Control Panel -> Administrative Tools -> find the "SQL Server 2005 Embedded Edition (MICROSOFT##SSEE)" service and ensure it is already started. 2.3 Click Start -> Run -> Type "cmd" (without quotation marks). Run the following command: sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E If it succeeds, we should see 1> 2.4 Detach the database with following command: 1> exec sp_detach_db 'db_name' (db_name is content database name that you would like to move database file to) 2> go 2.5 When it finishes, move the database files from %systemroot%\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data (by default, you may further verify it) to the new server. (both the .mdf and .ldf files are required to be moved) It may be "OfficeServers" instead of "Microsoft##SSEE", I think that is if you have installed MOSS though. Step Three: Re-attach the content database to the same SQL Server ====== 3.1 On the new server, Start SQL Server 2005 Management Studio with the SQL Server 2005 instance. 3.2 Right-Click Databases and click Attach. 3.3 Click Add and add the .mdf and .ldf moved. 3.4 Re-attach the old content database to new SQL Server 2005. Or use sp_attach_db, details here: http://msdn.microsoft.com/en-us/library/ms179877.aspx Let me know how you get on. :) - Brendan From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MacDonald, Mike Sent: Thursday, 16 October 2008 1:54 AM To: [email protected] Subject: RE: [OzMOSS] RE: Moving WSS 3.0 Databases I think I have looked at this one. The databases are in SQL EXpress Thank you, Mike MacDonald Securian Technology 1-800-395-2774 Opt 4 opt 4 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brendan Law Sent: Tuesday, October 14, 2008 2:44 AM To: [email protected] Subject: [OzMOSS] RE: Moving WSS 3.0 Databases Does this help? http://technet.microsoft.com/en-us/library/cc287899.aspx Are your databases in SQL Express or SQL Server? - Brendan From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MacDonald, Mike Sent: Tuesday, 14 October 2008 5:44 AM To: [email protected] Subject: [OzMOSS] Moving WSS 3.0 Databases All: Does anyone have "good" documentation from moving WSS 3.0 Databases from your root drive to a data partition? I have been trying to muddle through some I have and it is not working. Any help would be appreciated!!! Thank you, Mike MacDonald Securian Technology ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ________________________________ This email is intended for the named recipient only. The information contained in this message may be confidential, or commercially sensitive. If you are not the intended recipient you must not reproduce or distribute any part of the email, disclose its contents to any other party, or take any action in reliance on it. If you have received this email in error, please contact the sender immediately and please delete this message completely from any systems. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com ________________________________ This email is intended for the named recipient only. The information contained in this message may be confidential, or commercially sensitive. If you are not the intended recipient you must not reproduce or distribute any part of the email, disclose its contents to any other party, or take any action in reliance on it. If you have received this email in error, please contact the sender immediately and please delete this message completely from any systems. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
