View Single Post

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

One more tip... you might use Maintenance Plans instead of SQL Server
Agent/Jobs to do your un-attended backups.

~ Duane Phillips.

"Duane Phillips" <askme@askme.askme> wrote in message
news:aGppd.13$Tl.5821@news.uswest.net...
> 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