Create a New DB and Restore the Production DB

Andwian
Andwian Member Posts: 627
edited 2012-04-27 in NAV Three Tier
Dear Experts,

Is it needed and a best practice to periodically create a new DB for the Production DB?
Does it has any effects?
And which one is better, restore using SQL Backup or NAV backup?

Thank you in advance.
Regards,
Andwian

Comments

  • bbrown
    bbrown Member Posts: 3,268
    Why would you want to do this?
    There are no bugs - only undocumented features.
  • Andwian
    Andwian Member Posts: 627
    Nothing. I just think that it may 'refresh' the DB as a new DB :oops:
    And I observed that the DB file size is smaller than the old one. Save the disk space, and may be could boost performance :mrgreen:
    Regards,
    Andwian
  • bbrown
    bbrown Member Posts: 3,268
    Andwian wrote:
    ...And I observed that the DB file size is smaller than the old one...:mrgreen:

    Where are you observing this? If we are talking a SQL restore, then the new DB will be the same size as the old one. With a NAV restore it will be whatever size you create the empty database.
    There are no bugs - only undocumented features.
  • Savatage
    Savatage Member Posts: 7,142
    Maybe he means "Database Used" :-k

    If my database is 60gb with 85% used - Delete & Restore it would then show ..say 80% used.
    That's because all the keys have been recreated & everything is optimized.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • bbrown
    bbrown Member Posts: 3,268
    Savatage wrote:
    Maybe he means "Database Used" :-k

    If my database is 60gb with 85% used - Delete & Restore it would then show ..say 80% used.
    That's because all the keys have been recreated & everything is optimized.


    But only if you do a NAV backup/restore. I think he's looking at the SQL backup file size. But then we're all just guessing.
    There are no bugs - only undocumented features.
  • Andwian
    Andwian Member Posts: 627
    Sorry for not getting back earlier.

    I mean the *.mdf, *.ndf, and *.ldf file size in the windows program file, or Database | Alter.

    For the DB Used, I think it would be grow with time, so it is useless to see the DB used.
    I think DB Size could be grow, and the DB used % will be less again and again.

    Anyway, is it nice to do the routine creating a new DB and restoring for the Production DB?
    Regards,
    Andwian
  • bbrown
    bbrown Member Posts: 3,268
    I see no reason. Why are you thinking this might be something to do?
    There are no bugs - only undocumented features.
  • David_Singleton
    David_Singleton Member Posts: 5,479
    If it's not broke don't fix it. :mrgreen:
    David Singleton
  • deV.ch
    deV.ch Member Posts: 543
    That makes no sense, why would you do that? your mdf file would grow anyway... and in performance perspective its even worse if sql needs to enlarge the mdf file regularly. in fact its better to have a large file and size increase should happen as few as possible.
    If your ldf is too large then you do something wrong reagarding log file backup...

    So having smaller files will not not result in a performance gain, it might even decrase your performance.
    However doing regular maintanance jobs such as index reorg/rebuild is what you should do for performance.
    David Singleton wrote:
    If it's not broke don't fix it. :mrgreen:
    I totaly agree with that!
    My Blog
  • Andwian
    Andwian Member Posts: 627
    Hmm... I see..
    So it does not make any performance getting better.
    I thought before, that I may get the DB "refreshed" again, and get the performance better.:oops:

    Well, thanks everyone for the appreciable inputs!
    I can see it clearly now =D>
    Regards,
    Andwian
  • DenSter
    DenSter Member Posts: 8,307
    To keep the database 'fresh', you put in place proper maintenance. Watch this to learn about essential database maintenance on SQL Server: http://www.youtube.com/watch?v=0KbZkKdyZps
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Andwian
    Andwian Member Posts: 627
    Thanks Daniel! :D
    Regards,
    Andwian
  • DenSter
    DenSter Member Posts: 8,307
    You're welcome :mrgreen:
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories