Dead Lock at the time of backup

vyanku
vyanku Member Posts: 791
Our client have Nav 5.0 sp1 SQL option.
on trying to get backup on 17% or 18 % it stops and shows error ".........Table is dead locked".
They are not able to get the backup. They had tried at the time when nobody is using navision but they got same error.
Anybody got this type of problem for backup??

Comments

  • bbrown
    bbrown Member Posts: 3,268
    The best advice I can give you is don't use NAV backup with SQL. Use the SQL tools for backup.
    There are no bugs - only undocumented features.
  • hardik_shah
    hardik_shah Member Posts: 219
    vyanku i also facing same problem....Thats why i have done scheduling. it Runs midnight or early morning.
  • vyanku
    vyanku Member Posts: 791
    vyanku i also facing same problem....Thats why i have done scheduling. it Runs midnight or early morning.

    How you had shedule the backup? have you shedule it on backup by navision or by SQL?
  • Sog
    Sog Member Posts: 1,023
    I'm guessing SQL
    |Pressing F1 is so much faster than opening your browser|
    |To-Increase|
  • hardik_shah
    hardik_shah Member Posts: 219
    Right Sog

    I have done it with SQL...and its working fine
  • vyanku
    vyanku Member Posts: 791
    Thanks hardik_shah. :D
  • hardik_shah
    hardik_shah Member Posts: 219
    :)