morning Allister

I don't blame you for being concerned - my general Windows server knowledge is good but SQL is by far my weakest area (which I'm sure is obvious by...

It's just me unfortunately.

I'm pretty certain the backup was successful as MSEE reported it as completing successfully, and the .bak file is just over 4Gb in size.

Would a screen...

Hi Allister

I'm right-clicking the table > Edit , and pasted in this command:

DELETE FROM AuditTrail WHERE TimeStamp <= '2009/04/04'

It parses successfully but when I execute it, it gives...

Thanks buddy. Yes it has timestamp so it's easy for me to pick a cut-off date.

Fingers crossed that comnand should do the trick then 🙂

Hi Allister

many thanks for the quick response. Deleting all records in this table prior to a given date seems like the simplest way to approach this in the short term.

It...

thank you, I'll try those kb suggestions too. Just one question - the recommended scavenger time limit value of 30, I presume that's in decimal, not hex? It's not very...

hmm, they came up with no errors at all.

I also noticed that the 3 databases which are intermittently giving these errors are the 3 largest databases, all are > 1.4gb...

thanks for the reply Steve. Apologies but you're talking to an SQL novice here - would I run that command in Query Analyzer? Also can I specify by name...