Hi everyone,

I just want to let you know that the problem seems to be resolved now... I tried a couple of things but I think what resolved the problem was:

1)...

Hi Paul,

I will try to increase the initial size of tempDB files and see if it helps.

But I'm sure the hd size is not an issue, there is almost 1...

[font="Courier New"]Here is the log:

05/12/2009 10:16:19,spid144,Unknown,There is insufficient system memory to run this query.

05/12/2009 10:16:19,spid144,Unknown,Error: 701 Severity: 17 State: 123.

05/12/2009 10:16:19,spid144,Unknown,There is insufficient system memory to run this query.

05/12/2009 10:16:19,spid144,Unknown,Error:...

Hi,

I tried what Adam told me and it works much better now. Now, if a fetch returns -2, the cursor moves to the next db, there will be only one...

Ok, Thanks... I will try this and I'll let you know if it works well. 🙂

Hi,

I'm managing 10 SQL Servers here with around 10 to 30 DB each. I'm having a hard time to setup a script to automatically backup all database (user and system...