Change Default Directory When Create New Database?

anhnd
anhnd Member Posts: 11
edited 2012-07-13 in NAV/Navision Classic Client
Hi all,
how to do change default directory database when create new database

Thanks !

Comments

  • Chinmoy
    Chinmoy Member Posts: 359
    See attachments...



  • anhnd
    anhnd Member Posts: 11
    edited 2012-07-06
    Thanks Chinmoy !
    But instead of 'C:\Program Files\Microsoft SQL Server\MSSQL.....'
    in 'File Name' Column every time create new database, I want default directory is 'D:\Database...'

    How can do ?
  • Chinmoy
    Chinmoy Member Posts: 359
    See attachment. Hope this helps... :)

  • anhnd
    anhnd Member Posts: 11
    Thanks you very much !, Chinmoy.
  • Chinmoy
    Chinmoy Member Posts: 359
    You are welcome.. :)

    Please mark your post as solved.
  • Tvis
    Tvis Member Posts: 70
    Hi Chinmoy,
    I have been unable to make the default database settings (for instance D:\SQL) get used when creating a new database from NAV. It works fine if i create a new database directly in SSMS.

    Is it working for you?
  • Tvis
    Tvis Member Posts: 70
    Well, I think the above posting regarding default placings of SQL files and log from Chinmoy is incorrect for versions up to NAV 2009 R2, maybe it has changed in NAV 2013?

    For versions up to NAV 2009 R2 the only way to influence this is to move to master database because NAV is following the Master database.

    Anybody has any thoughts on this?
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Tvis wrote:
    Well, I think the above posting regarding default placings of SQL files and log from Chinmoy is incorrect for versions up to NAV 2009 R2, maybe it has changed in NAV 2013?

    For versions up to NAV 2009 R2 the only way to influence this is to move to master database because NAV is following the Master database.

    Anybody has any thoughts on this?

    My thought is that it's bloody annoying. :bug: This bug has been in NAV as long as I can remember, its about time they fixed it.

    Still it could be worse, I have seen some SQL applications that don't even let you change the directory when creating a database.
    David Singleton

Categories