Perhaps tomorrow I will reduce SQL RAM to 2.5 G, and add the -g700 setting, then restart.

Not sure if I'm reading it correctly

"Total Server Memory (kb)" shows a flatline at "100" in the graph. The "last", "avg", "min" and "max" boxes all show 3.2 G.

That...

I notice now, a week later, Task Manager only shows SQLSERVR.EXE using 105 meg. I was expecting it to be much higher. Yet I still get errors trying...

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...