Tech Support > Microsoft Windows > Windows CRM > Moving SQL Databases to another drive results in error
Moving SQL Databases to another drive results in error
Posted by McKenzie on August 18th, 2005


I am trying to move the CRM SQL Databases to another drive that has more
space and I get a replication error. Is there any documentation to help me
move these successfully??

McKenzie

Posted by John O'Donnell on August 19th, 2005


you can do this but you need to disable replication and re-enable afterwards
Use SQL Enterprise manager, select the database you want to move and then
choose the option (after right click) to detach the database,then move the database files (*.mdf and *.ldf) and then attach database back to SQL Server.

take full backups of the database before trying this just to be safe

--
John O'Donnell
Microsoft CRM MVP
http://www.mscrmfaq.us


"McKenzie" <McKenzie@discussions.microsoft.com> wrote in message news:6B01663A-0991-471A-BE46-F2A07C1B866F@microsoft.com...