Hello....I need to move my SQL 2008 Database for SCCM 2007 to another partition on the same server because the current partition is running out of space...is there a good article that anyone knows of on how to do this properly and anything that may need to be done within SCCM, etc? thanks in advanced

1) Stop all ConfigMgr. services including the MP 2) Move the database in SQL. You can use these two queries in the SQL Management Studio use master go sp_detach_db 'SMS_sitecode' go And this to attach the database again after you have copied the files. Use master go sp_attach_db 'SMS_sitecode','E:\SMSdata\SMS_sitecode_Data.MDF','E:\SQLlogs\SMS_sitecode_Log.LDF' go 3) Start the ConfigMgr. services againKent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund

thanks Kent...what is the best way to stop and make sure all the Config Mgr services are stopped, including the MP?

Hi - OPen up services.msc and check any of the services which starts with sms? Also you can use "ConfigMgr Service Manager" tool. This will tell you which are the components still running on the SCCM server.Anoop C Nair - This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

run preinst.exe /stopsite and after that stop the SMS Agent Host service.Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund