I'm setting up CRM on Small Business Server 2000. The
small business server had been originally installed
without SQL, so I added SQL 2000 using the small business
server installation wizard. I installed SQL in the
default location on C:\. I wanted to put the SQL program
files on C:\ and the data on D:\, but unfortunately the
installation wizard didn't give the option of specifying a
different location for the database files. I then ran the
CRM installation, which didn't give a choice of database
locations either. So I ended up with all the databases on
C:\.

How do I move the CRM databases from the C:\ drive to the
D:\ drive? I tried using SQL Enterprise Manager to detach
the databases and move them, but it wouldn't let me detach
the databases because they were being replicated.

If anyone knows of a way to move the databases that
doesn't involve reinstalling on D:\ nor SQL programming,
I'd really like to hear about it.

Thanks

If you had read the postings here, I went through the same process.

First make sure everyone is off.

Turn off SQL Agent.

Then for each of the CRM databases on the SQL server, do a "Backup database"
and save it to your D: drive. Then do a "Restore Database" and in that
wizard have it start pointing to your D: drive.

Simple as that (its far more compelx when its on a different server, or
worse, a different domain).

After your done, and everything works, check your error logs. I had a
catalog issue, and so I had to go to the MSCRM database, goto Full-Text
Catalog and I rebuilt and repopulated that and all my errors from the
migration went away.

good luck

-Gary

"Simon" <shepburn@tekagency.com> wrote in message
news:019601c376fb$d65cf130$a401280a@phx.gbl...