Just to confim, all users are using TCP/IP not Named Pipes

I guess this alias is being used by sqlcmd as it is the same name, although I can PING the...

Yes I misunderstood, as I thought a 32-bit is limited to 2GB but my maths were out, 32-bit = 4GB max

It all makes sense now.

Thanks

I am still confused as to how can a 32-bit application reference above 2GB without AWE 32 as the /3GB switch just tells the O/S not to use it but...

Sorry I don't think I stressed the specific understanding issue properly, I meant that for a 32-bit app to access more than 2GB does it require AWE to be enabled...

I thought I understood the /3GB and AWE settings until this thread.

I have a 4GB box SQL2005 Std Edition if I have the /3GB switch and AWE is NOT enabled,...

I am performing these steps (daily) which seem to work very well (as well as TLog backups during the day)

1) Backup Tlog

2) Set recovovery mode to simple

3) shrink database

4)...