Ashfaq
Wed Jul 14 05:51:45 CDT 2004
You can also try to changing the default paths for DB and log files in the
SQLServer settings. since i am sure like every other new DB CRM DB will
also use the default paths for the files.
Ashfaq
"Peter Lynch" <anon@anon.com> wrote in message
news:%23zZ8m2XaEHA.1356@TK2MSFTNGP09.phx.gbl...
> A very good question. For maximum performance and, more important,
> recoverability, the transaction logs and databases should be on separate
> partitions. As I understand it, the only point at which you can decide the
> primary database file and transaction log locations is when a SQL database
> is created - you cannot move them later. The CRM install program does not
> let you define transaction log/database physical file locations. So - if
my
> understanding is correct- you must create the database using T-SQL first,
to
> achieve the recommended physical file locations
>
> If any gurus can confirm or deny this I would be very grateful
>
> Peter
>
>
> "Bill" <anonymous@discussions.microsoft.com> wrote in message
> news:2c34601c4695f$a3519960$a501280a@phx.gbl...
> > Thanks for responding Matt, I was under the impression
> > that a Full recovery required at least putting program, &
> > data files/logs on a separate partition. In the IG it
> > says you need to create the databases ahead of time if
> > using multiple partitions. I assume theres no way to
> > affect the locations of files that are created during the
> > installation. This is going on a SBS2K3 server & I dont
> > want the CRM databases on the system partition. Are you
> > recommending not creating the databases ahead of time?
> > Bill
> >
> > >-----Original Message-----
> > >Bill,
> > >
> > >The CRM installation will automatically create the
> > databases for you. The
> > >recovery plan shouldnt have anything to do with this.
> > Once their created, you
> > >can verify the DB settings to make sure the recovery
> > mode is set to Full, but
> > >that should be all you need.
> > >
> > >Was there something more you were looking for?
> > >
> > >Matt Parks
> > >MVP - Microsoft CRM
> > >
> > >----------------------------------------
> > >----------------------------------------
> > >On Tue, 13 Jul 2004 15:13:20 -0700, "Bill"
> > <anonymous@discussions.microsoft.com>
> > >wrote:
> > >
> > >How do you create the 3 CRM databases if you are using a
> > >full recovery backup plan? I cant find an example & I
> > >want to make sure there isn't anything beyond
> > >the "obvious". I know very little about SQL Server.
> > >Thanks,
> > >Bill
> > >
> > >.
> > >
>
>