CRM 4.0 new deployment datbase file locations ????

[Jack]

Hi

When you deploy a new organization it seems that CRM tries to place the
database and log files in the same location as when first installed.

The problem is that we have moved log files to new disks on another drive
and when creating a new organization it tries to create the log file on the
old location even if we have changed the default location paths on the SQL
server.

Does CRM store a path for new databases/logfiles somewhere or how is this
working ?

The problem is that the organisations couldn't be created before we made a
directory on the old location and then we had to move it afterwards to the
new.

[Patrick]

A simple solution to this problem would be to deploy the databases to
whatever location. After this move the database and log files using
detach/attach in the SQL management studio.
--
Patrick Verbeeten (MCPD)
CRM/.NET Consultant

Tools for CRM Developers and Administrators
http://www.patrickverbeeten.com/Tools.aspx

Post by Jack
Hi
When you deploy a new organization it seems that CRM tries to place the
database and log files in the same location as when first installed.
The problem is that we have moved log files to new disks on another drive
and when creating a new organization it tries to create the log file on the
old location even if we have changed the default location paths on the SQL
server.
Does CRM store a path for new databases/logfiles somewhere or how is this
working ?
The problem is that the organisations couldn't be created before we made a
directory on the old location and then we had to move it afterwards to the
new.

[Dave Ireland]

Hi Jack,

So you've changed the server properties in SQL server to have different defualt
folders for data and logs, and when you created a new Org, it put them in
the old location? Has the SQL server been restarted since you changed the
defaults? That's the only thing I can think of, is that SQL hasn't been
restarted. As far as I'm aware, CRM just issues a 'create database' command,
and SQL takes care of the details like where to put the physical files.

Dave

Post by Jack
Hi
When you deploy a new organization it seems that CRM tries to place
the database and log files in the same location as when first
installed.
The problem is that we have moved log files to new disks on another
drive and when creating a new organization it tries to create the log
file on the old location even if we have changed the default location
paths on the SQL server.
Does CRM store a path for new databases/logfiles somewhere or how is
this working ?
The problem is that the organisations couldn't be created before we
made a directory on the old location and then we had to move it
afterwards to the new.