DB SIZE

SBN
SBN Posts: 26
edited 2010-04-17 in NAV/Navision Classic Client
Hello experts,
My DB size on SQL is 100GB,when I make buckup and restore on CSIDE DB this size is reduced to 20GB.

Please I want explanation for this.


Best Regards

Comments

  • kapil4dynamics
    kapil4dynamics Posts: 591
    SQL includes log file as well. That is one of the reason , in addition u cud have searched I think now Mibuso must be having atleast 50+ posts on db size.
    Kapil Khanna
  • SBN
    SBN Posts: 26
    Thank you kapil4dynamics for the answer and advice.
    I will make a search on this topic.
  • David_Singleton
    David_Singleton Posts: 5,479
    SBN wrote:
    Hello experts,
    My DB size on SQL is 100GB,when I make buckup and restore on CSIDE DB this size is reduced to 20GB.

    Please I want explanation for this.


    Best Regards


    The DB size is as big as you make it. Whats is important is how much database is used. Go to File Database Information and see there how much you are actually using.
    David Singleton
  • hardik_shah
    hardik_shah Posts: 219
    No need to worry i was also facing same problem. It is due to logfile.
  • Slawek_Guzek
    Slawek_Guzek Posts: 1,692
    It could be (not necessarily is) due to log size.

    BTW: The same approach is with native database. You could make it initially 100GB as well and restore NAV backup into it, couldn't you ?

    Slawek
    Slawek Guzek - www.yitron.co.uk
    Business Central, MS SQL Server, Wherescape RED;
  • DenSter
    DenSter Posts: 8,307
    To visualize the database file usage, you can run the Disk Usage report, it'll give you a pie chart of the files in use. Right click your database, Reports, Standard Reports, and select Disk Usage.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • SBN
    SBN Posts: 26
    Thanks to all,
    David Singleton wrote:
    The DB size is as big as you make it. Whats is important is how much database is used. Go to File Database Information and see there how much you are actually using.

    Firstly:When I said DB size was about 100GB on SQL and 20GB on Native ,I am speaking about the occupated size not the reserved ,according to DB information.
    Secondly:In few days I am going to restore the backup on SQL server,in order to compare the new size with the old.
  • David_Singleton
    David_Singleton Posts: 5,479
    SBN wrote:
    Thanks to all,
    David Singleton wrote:
    The DB size is as big as you make it. Whats is important is how much database is used. Go to File Database Information and see there how much you are actually using.

    Firstly:When I said DB size was about 100GB on SQL and 20GB on Native ,I am speaking about the occupated size not the reserved ,according to DB information.
    Secondly:In few days I am going to restore the backup on SQL server,in order to compare the new size with the old.


    There will be differences in database used in SQL and Native, also they report he numebrs slightly differently, but I can to imagine a 5:1 difference. I think its more likely you made a mistake in the restore, like maybe some company missing, or common data. Best is to make a FULL backup from the Native DB and restore that one to a new SQL. And see what happens.
    David Singleton
  • SBN
    SBN Posts: 26
    Hello,
    I made a backup and restore on SQL new db and the result was :the db size decreases from 120GB to 38GB. :?:

    Any help...
  • ara3n
    ara3n Posts: 9,258
    It could be the default fill factor on the database.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • David_Singleton
    David_Singleton Posts: 5,479
    Step one for me would be to figure outthe actual size of the database.

    Go File Database Information
    hit the TABLES button and copy paste into excel and add up the columns. This will show you have much data you have, which is a first starting point.

    What is this number?
    David Singleton

Categories