Hi !

I modified the script a bit like this

"Create table #BakDir(FileName varchar(255))"

" Insert into #BakDir exec xp_cmdshell 'dir E:\Name1\*.bak /B' "

If i do Select * from #BakDir i can...

It sounds like the nameresolution on the clients does not work when the server loses intenet access. Check if the clients can find the server when the internet connction is down.

In EM just rightclick on the server where the Db is and choose properties. It says it all on the generaltab.

/Jonas

I agree with rudy. 512 Mb is very low !! It is even low for just running OS on a server !

My SQL-servers has 4 Gb RAM !

Of course will I not remove it from model !! Mistake by me  !!

How about remove it from msdb , tempdb  and distribution ?? What will happend ??

I just want to secure...

Is it happening every night, or ?? At the same time ???

There is nothing in the system log ??

Does any program stop due to backup at the same time ??...