- Newby CRM question
- Posted by Bill on July 13th, 2004
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
- Posted by Matt Parks on July 14th, 2004
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
- Posted by Bill on July 14th, 2004
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
- Posted by Peter Lynch on July 14th, 2004
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...
- Posted by Ashfaq Ali on July 14th, 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...
- Posted by Edwin Garst on July 14th, 2004
Bill,
NTBackup will fail in SBS2003 unless simple recovery is selected for all
databases. The Volume Shadow Service is unable to freeze the database for
backup. I assume you have run the backup wizard on the todo list to set up
automatic, full backups.
If you change the model database to simple recovery then all new databases,
including the CRM databases, will be created with simple recovery as well.
You may want to investigate 3rd party backup solutions that support the full
recovery model better than NTBackup.
Edwin Garst
www.epconsystems.com
"Bill" <anonymous@discussions.microsoft.com> wrote in message
news:2c34601c4695f$a3519960$a501280a@phx.gbl...
- Posted by on July 14th, 2004
Good point, but I just set a batch file to run as a
scheduled task to shut down SQL server before backing up
& start again after finishing.
- Posted by Matt Parks on July 14th, 2004
Bill,
As mentioned in some of the other responses, you can change the default paths in
SQL that will be used when creating new databases. A differnet path can be
specified for the Load & Data files. When CRM creates the DBs, these defaults
will be used.
As for backups, I can never recommend people use Simple recovery. Unles you are
will ing to lose a day (or more) worth of data, you need to run Full recovery
and makes sure you are running both Data & log backups. As for the whole
NTBackup issue, I recommend using the SQL Server data maintnance wizard to
schedule periodic backups to disk. NTBackup can then backup those files and you
don't have to worry about backing up the actual database files. Using this
approach gives you the most flexibiliity in terms of recovery when you need it.
Matt Parks
MVP - Microsoft CRM
----------------------------------------
----------------------------------------
On Tue, 13 Jul 2004 22:01:35 -0700, "Bill" <anonymous@discussions.microsoft.com>
wrote:
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
