Dead Lock at the time of backup

vyanku

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??

bbrown

The best advice I can give you is don't use NAV backup with SQL. Use the SQL tools for backup.

hardik_shah

vyanku i also facing same problem....Thats why i have done scheduling. it Runs midnight or early morning.

vyanku

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

I'm guessing SQL

hardik_shah

Right Sog

I have done it with SQL...and its working fine

vyanku

Thanks hardik_shah.

hardik_shah