Backup issue

kitik
kitik Member Posts: 230
edited 2009-12-16 in NAV/Navision Classic Client
We just migrated one of our customers from 5.01 to SQL 5.01.
Our customer tells us that the time for the native backup (not the SQL backup) increased from 2 to almost 5 hours.

The backup creates 5 files of 2GB each one. First file takes 10 minutes. Second file takes 20 minutes. Thrird file takes almost 1 hour and so on.

Does anyone knows why is it happening? Does the backup usually takes longer when we use SQL?

Thanks in advance,
Laura
Laura Nicolàs
Author of the book Implementing Dynamics NAV 2013
Cursos Dynamics NAV (spanish) : http://clipdynamics.com/ - A new lesson released every day.

Comments

  • Savatage
    Savatage Member Posts: 7,142
    if they are now on SQL why are they using the Native backup?
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • kitik
    kitik Member Posts: 230
    Because he (the customer) feels more comfortable with the Native backup.

    Because we've only migrated to SQL (so far) the production db, but not all other databases (development and testing db), and we need to be able to restore companies at any moment on any database.
    Laura Nicolàs
    Author of the book Implementing Dynamics NAV 2013
    Cursos Dynamics NAV (spanish) : http://clipdynamics.com/ - A new lesson released every day.
  • Savatage
    Savatage Member Posts: 7,142
    kitik wrote:
    Because he (the customer) feels more comfortable with the Native backup.
    then I guess they will have to be more comfortable with the increase in time it takes for using native backup on a sql database.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • kitik
    kitik Member Posts: 230
    Ok, it takes longer.
    Is there something we can do to reduce the native backup time? No matter if it takes more than 2 hours, but al least less than the 5 is taking now.

    Thanks
    Salut!
    Laura Nicolàs
    Author of the book Implementing Dynamics NAV 2013
    Cursos Dynamics NAV (spanish) : http://clipdynamics.com/ - A new lesson released every day.
  • Savatage
    Savatage Member Posts: 7,142
    Go here & Download : w1w1bkup.pdf

    http://www.microsoft.com/downloads/deta ... laylang=en

    Also : w1w1isql.pdf - Has backup info
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • kapamarou
    kapamarou Member Posts: 1,152
    kitik wrote:
    Ok, it takes longer.
    Is there something we can do to reduce the native backup time? No matter if it takes more than 2 hours, but al least less than the 5 is taking now.

    Thanks
    Salut!


    And how much to restore :?:
  • kitik
    kitik Member Posts: 230
    Haven't tried. Don't need to try. They don't restore the production DB (till the day they need to).

    They backup the SQL production db.
    They restore to the Native development and testing db.

    In the future we will migrate to SQL also the dv and test db, so then they can use SQL backup with no problem. Till then they need to use the native backup. That's why I am asking...

    Salut!
    Laura Nicolàs
    Author of the book Implementing Dynamics NAV 2013
    Cursos Dynamics NAV (spanish) : http://clipdynamics.com/ - A new lesson released every day.
  • kitik
    kitik Member Posts: 230
    Yesterday I missed your las post, Savatage. I'll read the manual, see what can I figure out.

    kapamarou, my colleague says it takes 8 hours to restore. It also takes more to restore than before (it used to take 5 hours), but as I said that's not a problem, because restoring is something that they don't do every day on the production db, while backup is done every day.

    Salut!
    Laura Nicolàs
    Author of the book Implementing Dynamics NAV 2013
    Cursos Dynamics NAV (spanish) : http://clipdynamics.com/ - A new lesson released every day.

Categories