Also has more or less similar problem where the issue was not even the backup but the log file.

We couldn';t backup the log file and it was increasing at least...

Tricky & i think it's better than not knowing at all.:cool:

Nyc Q tx....

😉

Yahh neehhhh... At least I know now.

Couldn't agree with you more about @SQLFRNDZ's comment, and why would you want...

this helped me a lot and xp_logininfo helped me even more on multiple servers(SQL 2k8)

I believe mine is the memory issue, see below:

How do you change memory settings if you can't even connect to the server.

When connecting through SQLcmd I get the same error....

hi,

I have tried what Reecha Mishra has advised as per above with no joy, is there anything that I am missing.

I am running Win server 2008 R2 with SQL server...

Thanks for an update but what if I have 2 instances on 1 machine, one SQL 2k5 which is not being used and it is a named instance and the...

CoUNTRY1 COUNTRY2 COUNTRY3 TBL1

/ \ ...

Can't complain...

Also thaught that a logical operator is correct but a lil explanation will be more apreciated from this side.

Once beaten twice shy

Happy wif the question and the answer...

I'll also add on by saying that the qry will run till you add the "commit tran"

statement at the end of the 1st qry