Thank you for your reply, it is clustered, I will read this article and share it with IT who is responsible for all cluster related stuff,

LL

Hi Roy, thank you for our reply. I know why I take the backup. My plan as I think it should be, is like this: on a new server do...

Hi, thank you for the reply. The problem was solved like this. We did another restore with replace from a different backup for this db. It finished with no problem...

Hi Silverfox, thank you for the reply. The EM says loading\Suspect There is more to this. This process also generated exception access violation

Event Type: ...

Hi, MJ.

When I run select * from sysfiles I see only one log file log01.

when I query sysaltfiles select * from master..sysaltfiles i see log02 file that belongs to...

Sql 2000, SP4

I did some more queries in master.dbo.sysaltfiles and found this file there. how come it doesn't show up in db properties?

Hi, thank you for your reply, dir command worked, I can see the file.

chck disk showed this

CHKDSK is verifying files (stage 1 of 3)...

43056 file records processed.

File verification completed.

196 large...

Hello, I had exact same problems testing proxy on a not clustered environment.Proxy has all rights required, when the job owner is testuser that has only access to one table...

didn't help, had to drop all subscriptions and publications. There is more to it. Some jobs started to hang too well past their next schedule run. I restarted Sql Server...

Thank you David, I read it and already sent them an email for a quote, let's see if we can afford it. LL

Thank you for your reply, actually I am looking for a tool that will use both, logs and trace. So far I saw only tools that only read logs...

I googled it now and saw that the company withdrew it from the market from January 1 2009, not available for purchase or evaluation. LL

Thank you, that's what I am on now, making IT to move faster to give me other options, thanks god it is only testing environment.

It started with one db1 backup failure, then It worked for a couple of days, now this db1 (full and trans) and other db2 (full) are failling. But still there...