Obviously the file 'D:\sqlbackups\admin_backup_201108141900.bak' doesn't exist on your system. Please check if the file is present first. Is the name exactly the same as 'admin_backup_201108141900.bak'?

Remove the last backslash in your path for the backup file, i.e.:

SET @path = 'D:\downloading\test' --Path of the Backup File instead of:

SET @path = 'D:\downloading\test\' --Path of the Backup...

Thanks for the replies! I will go with option 1: put the tempdb logfile and the logfile on a seperate disk. I can always move the logfile to another disk...

Got the solution!

To get the Alert working, you should leave the Type to 'SQL Server event alert', database name to <all databases> and the error number to 14161. The...

Solved! 🙂

The problem was that an user with only the db_creator serverrole was somehow owner of the msdb database. I changed it to sa and now it works fine.

Thanks...

No problem. I now understand that in the past I have set up relay mail, apparently to make SMTP work. I obviously did not have to do that... (please take...

Well, my account does point directly to the email server. I just followed Microsofts instructions on how to configure Database mail (it says first you have to add the SMTP...

Yep, shouldn't I?

I tried it to send mail from the same machine (telnet localhost 25). That works. Besides, there is one weird thing I have to telll. Until I removed it, there...

10/13/2010 12:05:29,,Information,95,The mail queue was started by login "SQL_MEDICAL\stakes".,,,,10/13/2010 12:05:29 PM,SQL_SERVER\stakes

10/13/2010 12:05:27,,Information,94,The mail queue stopped by login "SQL_MEDICAL\stakes".,,,,10/13/2010 12:05:27 PM,SQL_SERVER\stakes

10/13/2010 12:05:23,,Information,93,The mail queue was started by login "SQL_MEDICAL\stakes".,,,,10/13/2010 12:05:23 PM,SQL_SERVER\stakes

10/13/2010...

Thanks, but that's well configured (like you are saying)

Got it working! I disabled the User Account Control policies in the Local Security Policy-Local Policies-Security options and restarted the system. Don't know which policy did it for me. I...

@ratheesh.K.Nair: Windows authentication

@chetanr.jain: I'm using a local account and the servers are not in a domain. I see where you are going to, but then the question is...

Ok, I got something. From the logon event data on stsqlserver3:

SubjectUserSid S-1-0-0

SubjectUserName -

SubjectDomainName -

SubjectLogonId 0x0

TargetUserSid S-1-5-7

...

Well, there isn't any error message. At least, I didn't find one in the Windows Event Log. I can see login messages though. Loggin in is not the problem, SSMS...