Thursday, March 22, 2012

Backup Scheduling

After I set a backup schedule, although it works as set, when I come back to
try to modify it the schedule is set back to some default. Is this normal?
It happens both on my SP4 installation and at my clients site. Thanks for
any enlightenment.Can you provide more details. Where do you do this? EM? What menu choices an
d dialogs? What exactly
does "set back to some default" mean?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sborsher" <sborsher@.discussions.microsoft.com> wrote in message
news:97BF1104-BA0C-4DCD-86B3-94B1B17E50D8@.microsoft.com...
> After I set a backup schedule, although it works as set, when I come back
to
> try to modify it the schedule is set back to some default. Is this normal
?
> It happens both on my SP4 installation and at my clients site. Thanks for
> any enlightenment.|||Thanks for the reply. The backup is in SQL Server 2000 (running on Windows
2000 server). Right click a database and select All Tasks | Backup database
...
When I change the default backup settings they are set back to default the
next time I come back to Backup database although the setting I made are
working correctly. WHere are the Bacjup parameters saved?
"Tibor Karaszi" wrote:

> Can you provide more details. Where do you do this? EM? What menu choices
and dialogs? What exactly
> does "set back to some default" mean?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "sborsher" <sborsher@.discussions.microsoft.com> wrote in message
> news:97BF1104-BA0C-4DCD-86B3-94B1B17E50D8@.microsoft.com...
>|||The options you set in this dialogs are not saved. If you select "Schedule",
and Agent job is
created with the BACKUP command as you selected. You can edit that job.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sborsher" <sborsher@.discussions.microsoft.com> wrote in message
news:1ED36100-F04F-4EDC-8EAB-F0352D957C26@.microsoft.com...[vbcol=seagreen]
> Thanks for the reply. The backup is in SQL Server 2000 (running on Window
s
> 2000 server). Right click a database and select All Tasks | Backup databa
se
> ...
> When I change the default backup settings they are set back to default the
> next time I come back to Backup database although the setting I made are
> working correctly. WHere are the Bacjup parameters saved?
>
> "Tibor Karaszi" wrote:
>|||Tibor,
Thanks. I found it (them).
"Tibor Karaszi" wrote:

> The options you set in this dialogs are not saved. If you select "Schedule
", and Agent job is
> created with the BACKUP command as you selected. You can edit that job.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "sborsher" <sborsher@.discussions.microsoft.com> wrote in message
> news:1ED36100-F04F-4EDC-8EAB-F0352D957C26@.microsoft.com...
>sql

No comments:

Post a Comment