How I can increase the size of the database?

kanika
kanika Member Posts: 247
edited 2012-01-31 in NAV/Navision Classic Client
How I can increase the size of the database? it's 92%
thanks.

Answers

  • postsaurav
    postsaurav Member Posts: 708
    Hi kinka,

    which database? Native or Microsoft SQL.


    Thanks & Regards,
    Saurav Dhyani
    http://saurav-nav.blogspot.com/
    Thanks & Regards,
    Saurav Dhyani

    Do you Know this About NAV?


    Connect - Twitter | Facebook | Google + | YouTube

    Follow - Blog | Facebook Page | Google + Page
  • kanika
    kanika Member Posts: 247
    NAV 2009 Classic AP1 with SQL
  • kanika
    kanika Member Posts: 247
    sorry SP1
  • manikandan
    manikandan Member Posts: 160
    Hi kinka,

    To increase the size of a database :
    1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
    2. Expand Databases, right-click the database to increase, and then click Properties.
    3. In Database Properties, select the Files page.
    4. To increase the size of an existing file, increase the value in the Initial Size (MB) column for the file. You must increase the size of the database by at least 1 megabyte.
    :thumbsup: :thumbsup: :thumbsup:
    Regards,
    Muthu
  • akhileshek
    akhileshek Member Posts: 28
    Hi kinka
    You can Increase the size of database from Nav . :lol:
    File>Database>Alter database
    go to database file tab Increase the size of NDF file >>Ok... \:D/

    Regards
    Akhilesh
    regards

    Akhilesh

    http://navconsultant.com/

    http://www.linkedin.com/in/akhileshek
  • kanika
    kanika Member Posts: 247
    There is 2 NDF, NAVISION_DATA and NAVISION_1_DATA

    Do I must increase both?
  • manikandan
    manikandan Member Posts: 160
    Hi kanika ,
    yes,u must increase 2 NDF.ie, NAVISION_DATA and NAVISION_1_DATA
    :thumbsup:
    Regards,
    Muthu
  • bbrown
    bbrown Member Posts: 3,268
    manikandan wrote:
    Hi kanika ,
    yes,u must increase 2 NDF.ie, NAVISION_DATA and NAVISION_1_DATA
    :thumbsup:
    Regards,
    Muthu


    No. You need to increase whichever one needs it. The first one rarely needs to be increased in size depending on how large it was made in the first place. Things like addign a lot of companies will increase the demand on the first file. It's the second one that holds all the data and usually needs to be increased.
    There are no bugs - only undocumented features.
  • David_Singleton
    David_Singleton Member Posts: 5,479
    kanika wrote:
    There is 2 NDF, NAVISION_DATA and NAVISION_1_DATA

    Do I must increase both?

    Kanika,

    this is a little confusing.

    Best will be if you post the EXACT details of all the files you have in your NAV/SQL database include all the ldf,mdf and ndf files along with the size of each file and also look to see how much space is used in them.

    The naming convention you are showing does not look normal to me. And you can't expect correct answers if you don't give correct and complete information.
    David Singleton
  • kanika
    kanika Member Posts: 247
    Well, I increased both NDF and the database is 23%

    Thanks

Categories