what is a RAM on your Windows 2003 Ent Server?

check

SQL Server only uses 2 GB of memory even though the AWE option is enabled

http://support.microsoft.com/kb/811891

---

and

AWE Adventures

use the

 CPU counting utility. CPUCount.exe

http://www3.intel.com/cd/ids/developer/asmo-na/eng/275339.htm

Check the article:

SQL Server support in a hyper-threaded environment

http://support.microsoft.com/kb/322385

and try

Intel provides a CPU counting utility. CPUCount.exe

<have check and TCP>

whattcp\ip port is it using?

can you access by using IP address instead of server name?

did you rename the box after sql server installation?

 To have the tape ejected at the end of the script, add ', UNLOAD'

e.g.

BACKUP DATABASE yourDB TO TAPE='\\.\TAPE0' WITH NAME='yourDB COMPLETE', UNLOAD

try the script:

PROC AutoStart_SQLAgent

autostart SQL Server agent when SQL Server starts on a Windows 95 or Windows 98 computer

http://vyaskn.tripod.com/code/sql_server_agent_autostart.txt

I did not get any error see below: check if you installed fresh sql server  service pack

SELECT CONVERT(real,'689.99')

---result---------------------

689.98999

(1 row(s) affected)

---

try RETAINDAYS

or backup log as part of Mainteneces plan where you can specify when to delete the old backup files too

BACKUP

LOG [Northwind]

Joshua Perry:

you wrote:

< The sql server should just build a new log file for the database. >

FYI: sql server does not build a new...

you can try:

XP_CRYPT

http://www.xpcrypt.com/products.html

yes, msdb:

start collect and analyze data from queries:

select

j.name,j.enabled,

sh

.active_start_date,

sh

try

HP sql server free sizer:

it will help you:

http://h71019.www7.hp.com/ActiveAnswers/cache/70729-0-0-225-121.html?jumpid=reg_R1002_USEN

make sure the emails in format:

for example:

username@domain.com

also try to send from your outlook

<Server does not exist or access denied>

can you access the sql serve (let say from Query Analyzer)?

Also what is OS\Edition\version\SP\ security patch level(fresh or a lot missed)

same for sql server:...