web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / SQL Server filegroups ...
Microsoft Dynamics CRM (Archived)

SQL Server filegroups and CRM

(0) ShareShare
ReportReport
Posted on by Jeff Ballard 390

I'm not an expert in admin of SQL Server (pretty good as a developer).  I have a customer that wants to use different filegroups for their data files with their CRM database.  Is that possible?  Does CRM give you the option to select a filegroup during the install?

Related: can I pre-create the CRM databases (empty, no schema, nothing other than the shell) prior to the install and tell CRM to use those databases? 

I'm going to investigate both but I thought someone might have the quick & easy answer.

Thanks,

Jeff

 

*This post is locked for comments

I have the same question (0)
  • alf Profile Picture
    alf 17,915 on at

    Hi Jeff,

    CRM does not give you an option related to data files or file groups when it installs.  However, it is just a plain vanilla sql server database.  So after crm is loaded and running you could move the data files around or create two log files, etc.

    As for pre-creating the crm databases - I do not believe it is an option, but am not 100% sure. 

  • Jeff Ballard Profile Picture
    Jeff Ballard 390 on at

    Thanks for the quick reply, Alex.  I suspected the first and I verified the second - you can NOT pre-create the database.  If you do, you get the following errors during the verification process:

    • The following databases already exist on the specified SQL Server: MSCRM_CONFIG
    • The following databases already exist on the specified SQL Server: <CompanyName>_MSCRM

    We told the customer that it will create it's databases wherever SQL Server is set up to put the data and log files and that they will have to do as you suggested by creating the filegroups, etc. after the install.

    Thanks again,

    Jeff

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans