We are running Office Sharepoint Server 2007 on a Hyper- Virtual Machine running Windows 2003. The server is running out of the spaces. I am thinking to move the Sharepoint databse to another virtual hard disk on the same VM. Since I done't see SQL Server Management Studio, I assume we are using SQL Server 2005 Express Edition. Can someone give me step by step how to move the SharePoint database from C to D?Bob Lin, MVP, MCSE & CNE Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net How to Setup Windows, Network, VPN & Remote Access on http://www.howtonetworking.com

Refer http://sharepointsherpa.com/2008/04/18/sharepoint-2007-move-content-and-configuration-databases/ http://blogs.msdn.com/b/shaden/archive/2007/07/05/moving-the-sharepoint-databases-to-a-new-sql-server-instance.aspxMy SharePoint Blog http://dhireny.blogspot.com

Hi Bob, Generally speaking you would need to follow the steps below: 1. Backup both the SharePoint Farm and SQL databases. 2. Stop the SharePoint services. 3. Detach SharePoint databases within SQL Server (data and log files). 4. Attach databases to target location. 5. Run DBCC CHECKDB for structure consistency. 6. Restart SharePoint services. On a separate note, you suggest that space is running out, I recommend you invest in SQL Server Standard or Enterprise Edition as the SQL Express has 4Gb Db size limit. hth,Chirag Patel, MCTS @techChirag techChirag.com

Hi Bob, Generally speaking you would need to follow the steps below: 1. Backup both the SharePoint Farm and SQL databases. 2. Stop the SharePoint services. 3. Detach SharePoint databases within SQL Server (data and log files). 4. Attach databases to target location. 5. Run DBCC CHECKDB for structure consistency. 6. Restart SharePoint services. On a separate note, you suggest that space is running out, I recommend you invest in SQL Server Standard or Enterprise Edition as the SQL Express has 4Gb Db size limit. hth,Chirag Patel, MCTS @techChirag techChirag.com

Thank you for the tips. I moved all data and they work fine except Ican't start Windows SharePoint ervices Search. Windows SharePoint Services Search Required on Farm, not running Stopped Start Error WSS_Search_2003TS1 on np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query contains user-defined schema. Databases must be empty before they can be used. Delete all of the tables, stored procedures and other objects or use a different database. Bob Lin, MVP, MCSE & CNE Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net How to Setup Windows, Network, VPN & Remote Access on http://www.howtonetworking.com

The issue is with the database "WSS_Search_2003TS1" already exisitng in the database server. You will need to rename/delete it http://blogs.msdn.com/b/hanz/archive/2009/02/03/how-to-fix-the-error-when-restarting-windows-sharepoint-services-search.aspx http://social.microsoft.com/Forums/en-US/Offtopic/thread/717f6c2d-b90b-4b6e-8cdb-a18620b799ba My SharePoint Blog http://dhireny.blogspot.com

I renamed it first, but that doesn't work. Then I delete the data. Still get the same error message. What should I try?Bob Lin, MVP, MCSE & CNE Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net How to Setup Windows, Network, VPN & Remote Access on http://www.howtonetworking.com

Hi, According to your description, I agree with Dhiren’s said. You must make sure that the Windows SharePoint Services Administration service is started on all farm service before running a backup. This service is not start by default on standalone installations. In addition, make sure that the 'Service Account' and 'Content Access Account' service account specified are the same. They should not be working with two separate accounts. If it still does not work, Stop the service and while starting it again specify a common service account and create a new Search Database. Best Regards David Hu