Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-10 : 08:51:43
|
| Akhil Agarwal writes "Hi,Schedule is not enabled when i clicked onon right click Select Datbase->All Task -> Backup Databse On Backup Database Main Screenwhen i seleced click on Scheduled and made changes and click on OK.Next time when i repeat the process it showing the default schedule not my schedule.How can i store my schedulue ???looking for your reply.RegardsAkhil" |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-07-10 : 12:38:26
|
| I think I understand you you're doing.If you right click on DATABASE to backup as you explained, you will get the "BACKUP DATABASE MAIN SCREEN"This screen doesn't check to see if a scheduled job for this backup exists. It ASSUMES this is a MANUAL backup. If you select the scheduling options and click OK, it creates a job with the appropriate schedule. However, the next time you "right click Select Datbase->All Task -> Backup Database "It will show you the same blank screen (and defaults).Each time you schedule this way, a new job is added to the job list (It doesn't overwrite jobs, but renames them by appending a number after the name).This particular interface was not designed to maintain backup jobs, but to backup manually, and for convenience convert manual jobs to scheduled jobs for continued use.I believe your options are to use Database Maintenance Plans, or to manage the schedule in the JOBS list instead. If you look, you should find a job with a schedule matching the one you created through the "manual" interface.Edited by - kevin snow on 07/10/2002 12:39:37 |
 |
|
|
|
|
|
Backup Database