The field is UTC time, but if you put in a paramter for hour it bombs out like I said after 16 +..... Is there a better way to do...

Great! thanks. I am seeing that it's happening around 2-3 am.

Well I'm pretty sure it's the tempdb that's my problem, but no I haven't figured out what it is.

I did see this just now

Date 3/15/2010 12:00:21 AM

Log SQL Server (Archive #1 - 3/15/2010 6:32:00 AM)

Source spid18s

Message

This instance of SQL Server has been using a process ID of 5964 since 3/12/2010 3:12:41...

My transaction logs are backed up every hour. and a full back up at midnight

Looked at that...

here is what space_used says

tempdb 101.75 MB 95.68 MB

1544 KB 744 KB 736 KB 64 KB

When I looked at the server memory options this is what it's set too?

MIN is 0(mb)

MAX is set to 2147483647(mb)

other memory options

Index creation memory = 0

Min memory per query =...

Where can I set those limits? I looked at the jobs and we don't really have anything running at the time it crashed.

I have 12 GB of memory and running service pack 2. Could this bad memory problem?

I had no problems last night and the log file didn't fill up and all the backups ran as normal. I'm going to continue to monitor this but I think...

I have set the backups to every half hour for the rest of the night and I'm also profiling the DB....maybe I'll catch something there?

Yes, I can change it. Would it be a better solution for me to also have them back up all day instead of the 6-9 window? Not sure as to...

The log file that just now backed up at 3:30 is 18kb and the drive is 30GB....

what I just noticed was that the .trn files are not located on...

There is also this error message

Internal I/O request 0x4F978B38: Op: Write, pBuffer: 0x08830000, Size: 983040, Position: 14789678592, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x71889600, OffsetHigh: 0x3, m_buf: 0x08830000, m_len: 983040,...

They are showing that they've suceeded in the jobs, but my error messages are quite different. Here is what the additional error log says, but it's not helpful because I...