# 3274 ElevateDB Manager Script Debugger Can Cause Deadlock with Remote Sessions

---

I am trying to create a job to backup 2 ElevateDB databases, using ElevateDB Manager (everything on 2.03b19). However the Job did not appear to work so I started to break the SQL up into bits.

I started with this query, which works fine -

BACKUP DATABASE npchSGPT
AS "npchSGPTDataBaseDailyBackup"
TO STORE "Database Backup"
INCLUDE CATALOG

However, when I try to run the same sql using a script as below -

SCRIPT
BEGIN
EXECUTE IMMEDIATE 'BACKUP DATABASE npchSGPT
AS "npchSGPTDataBaseDailyBackup"
TO STORE "Database Backup"
INCLUDE CATALOG;';
END

The Backup Database SQL is executed and a message is displayed to say it has completed in n.nn secs but then the script does not complete and hangs for a while before coming up with the error -

ElevateDB Error #506 Cannot lock the session manager (ID: 1)