SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 04:56 AM
| ||||
| ||||
 SQL Server 7 Backup Problems 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      |
|
02-29-2008, 04:57 AM
| |||
| |||
| 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 |
|
02-29-2008, 04:57 AM
| ||||
| ||||
| 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 > > > |
Linear Mode
