I did enable AWE last week, set max memory to 3G, then restarted SQL.

So, would something like -g700 be appropriate as a startup parameter to help the Linked Server memory issue ??

You can use BCP to output from T-sql to a text file

Anything interesting in the Server's Event Log ??

Maybe hardware, like a controller card ??

If you know the name of the text file related to the maint plan for that day, you could send it as an attachment.

I'm not fa,iliar with the MemToLeave problems. I will have to read up on it.

Thanks

I rebooted this morning.

I thought AWE was set correctly. I'll have to read up on it ... forgot the details.

I just ran:

sp_configure 'awe enabled', 1

RECONFIGURE

I will restart SQL during...

Windows Server 2003 R2 Standard Edition SP2

2.8 Gz, 4 G RAM

@@Version:

Microsoft SQL Server 2005 - 9.00.4060.00 (Intel X86) Mar 17 2011 13:20:38 Copyright (c) 1988-2005...

Narrowing it down a bit. getting these messages yesterday on the server running the original backups, and the job that was supposed to backup 10 databases only backed up 2...

Strange. I re-ran the job a 2nd time, and the restore of Database A completed normally this time (using a new DIFF backup), but the restore of Database C...

I was also going to mention FORFILES. I use it for a similar purpose: Deleting trace files older than X days. I schedule it through SQL Scheduled Jobs.

[font="Courier New"]forfiles...

Another puzzle with this:

When I run an INSERT statement from my MSSQL query window against the live MySQL database, but a TEST table it works fine. But if I...

Before I make lots of changes on a production server, do you know which settings might apply to my situation ? That I can access the MySQL data via...

You could try looking at your transaction log backups, and see what time of day they were very large. Then try to figure out what was running at that time.

I...

I never solved it. I just omit results older than 'X' days.