View Single Post

   
  #2 (permalink)  
Old 02-29-2008, 04:57 AM
Duane Phillips
 
Posts: n/a
Default Re: SQL Server 7 Backup Problems

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" <alijsyed@hotmail.com> wrote in message
news:26c82868.0411231305.75246cc0@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




Reply With Quote