Does the SA account and password match an accout on your server that has
authority to perform the backup?
Check the logs in SQL Enterprise Manager. Your installation may be
different, but you should find the logs in a SQL Enterprise Manager location
similar to this:
Console Root/Microsoft SQL Servers/SQL Server Group/[Server Name
Here]/Management/SQL Server Logs/[Log Names]
~ Duane Phillips.
"Ali Syed" <al******@hotmail.com> wrote in message
news:26**************************@posting.google.c om...
I am having problems trying to get SQL server Agent to run an
unattended backup of my databases.
I setup (or think I did) a schedule in maintenance but it doesn't
work.
Is there a website or link where I can get step by step instructions
for setup of a backup using sql server agent or anything regarding
unattended backups in sql server 7?
Any help is appreciated
Ali