Options

SQL Server database only had 1 x mdf

guardiooguardioo Member Posts: 13
edited 2013-04-08 in NAV Three Tier
I had create the database in SQL server.

Unfortunately after few months of using it,

I only see having 1 x database.mdf

When i try to expand database and having 1 x database_2.ndf,

It doesnt allow me to create.

Do you guys have any idea on this?

Comments

  • Options
    Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    I'm not quite sure what you mean.

    NAV databases are created from within the Classic Client, not Mgt studio.

    Expanding databases works automatically for most installations. Extra files are only usefull in rare situations in very large implementation.

    If you only see a mdf file than normaly the customer started off with a cronus database which for whatever reason only has an mdf file.
  • Options
    bbrownbbrown Member Posts: 3,268
    ...Expanding databases works automatically for most installations...

    Not sure what you mean by this.


    One thing I've noticed with NAV 2013, is that the W1 CRONUS has only the 1 data file (*.mdf) but the NAV version has both the (*.mdf) and the (*.ndf). Not that it matters.
    There are no bugs - only undocumented features.
  • Options
    Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    I asume most customers have autogrow enabled.
  • Options
    bbrownbbrown Member Posts: 3,268
    Yes, but they should still be managing the growth manually.
    There are no bugs - only undocumented features.
  • Options
    Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    My guess is 99% do not do that.

    Although they should.
  • Options
    bbrownbbrown Member Posts: 3,268
    Agreed.
    There are no bugs - only undocumented features.
Sign In or Register to comment.