I’m frequently creating new databases in NAV. One annoyance was NAV’s insistence on the default file location. In my dev environment this was always where I had installed SQL.
Not where I want my databases.
I spent some time investigating and after watching file system and registry access on both server and client I wasn’t able to see it grab any relevant values from those spots. From what I can tell after watching packets between client and server with a packet sniffer, the NAV client is parsing the file location from the sp_helpfile stored procedure. The solution? NAV is essentially following the Master database.
How to move system databases in SQL Server:
http://msdn.microsoft.com/en-us/library/ms345408.aspx
Just move the Master database to the spot you’d like the default file locations. Now when I specify Database Files… Yay!
The only downside is that is also will want to put the Transaction Log Files in the same file path. Small price to pay. 
Does anyone else have a better way of doing this? It would at least be nice if NAV could somehow use the default file locations specified within SQL.
Nice trick which is rather helpful when creating databases.
I also tried moving the Mastlog.ldf but as you write the path is not used i NAV –> which seems a bit strange. But of cause i create the databases on my labtop and only have one disc in that one so I usually throw all the files in the same folder anyways.
March 2, 2009 @ 10:08 am
Nice trick which is rather helpful when creating databases.
I also tried moving the Mastlog.ldf but as you write the path is not used i NAV –> which seems a bit strange. But of cause i create the databases on my labtop and only have one disc in that one so I usually throw all the files in the same folder anyways.
March 2, 2009 @ 10:08 am
Nice trick which is rather helpful when creating databases.
I also tried moving the Mastlog.ldf but as you write the path is not used i NAV –> which seems a bit strange. But of cause i create the databases on my labtop and only have one disc in that one so I usually throw all the files in the same folder anyways.
March 2, 2009 @ 11:08 am
Nice trick which is rather helpful when creating databases.
I also tried moving the Mastlog.ldf but as you write the path is not used i NAV –> which seems a bit strange. But of cause i create the databases on my labtop and only have one disc in that one so I usually throw all the files in the same folder anyways.
March 2, 2009 @ 5:08 pm
SQL Server Management Studio – right click on the Server – property – Database settings – Database default location
June 30, 2010 @ 12:11 pm
The post of content is very interesting and exciting. I learned a lot from here.The content from simple to complex, so all of you can come in . No matter you want to see what can be found.By the way ,there are some websites is also very wonderful,you can go and see.such as vibram fivefingers kso trek
July 8, 2010 @ 8:22 am