By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,490 Members | 1,398 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,490 IT Pros & Developers. It's quick & easy.

CHANGED backup time, but still occuring

P: n/a
Hello. Have a strange one here. I'm backing up databases locally to a drive
on the server daily. I needed to change the time of the backup, and did
that, but it's still occuring at the old time.

I deleted the old job, and recreated it with the new time. I won't know
until tonight at 12:00 whether that worked or not.

Can someone tell me where it saves the maintenance schedules and how it
kicks it off? I'd like to take a look at it to see if it's still there.

I'm a little bit of a newbie on SQL server, so be gentle. :-)
--
If responding to me directly, please take out "REMOVE" from my e-mail
address.

Thanks!
Doug
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Doug" <dg*****@hotmail.com> wrote in message news:<9q******************@newssvr31.news.prodigy. com>...
Hello. Have a strange one here. I'm backing up databases locally to a drive
on the server daily. I needed to change the time of the backup, and did
that, but it's still occuring at the old time.

I deleted the old job, and recreated it with the new time. I won't know
until tonight at 12:00 whether that worked or not.

Can someone tell me where it saves the maintenance schedules and how it
kicks it off? I'd like to take a look at it to see if it's still there.

I'm a little bit of a newbie on SQL server, so be gentle. :-)


Can you give some more information on exactly what you did (and which
version of SQL Server you're using)? It looks like you're using the
maintenance plan wizard - which databases did you choose to backup,
what time did you select for the backups, what time are they actually
running at, what happens if you schedule a BACKUP command in a
scheduled job instead of using the wizard etc. And is there anything
relevant in the SQL Server Agent log?

Simon
Jul 20 '05 #2

P: n/a
I think I have it fixed, although I don't know the exact cause.

I used the Wizard to create the backup job for all databases. I decided to
break out the database that was having the problem into it's own job. Then,
I deleted the other (all) plan, and recreated it without including the
trouble database.

No problems last night. Who knows what will happen tonight, but I feel more
confident. Something must have become corrupt.

BTW, to answer the questions, this is SQL 2000 server. There was nothing in
the SQL log that would point to a problem.

Thanks!
Doug

"Simon Hayes" <sq*@hayes.ch> wrote in message
news:60**************************@posting.google.c om...
"Doug" <dg*****@hotmail.com> wrote in message

news:<9q******************@newssvr31.news.prodigy. com>...
Hello. Have a strange one here. I'm backing up databases locally to a drive on the server daily. I needed to change the time of the backup, and did
that, but it's still occuring at the old time.

I deleted the old job, and recreated it with the new time. I won't know
until tonight at 12:00 whether that worked or not.

Can someone tell me where it saves the maintenance schedules and how it
kicks it off? I'd like to take a look at it to see if it's still there.

I'm a little bit of a newbie on SQL server, so be gentle. :-)


Can you give some more information on exactly what you did (and which
version of SQL Server you're using)? It looks like you're using the
maintenance plan wizard - which databases did you choose to backup,
what time did you select for the backups, what time are they actually
running at, what happens if you schedule a BACKUP command in a
scheduled job instead of using the wizard etc. And is there anything
relevant in the SQL Server Agent log?

Simon

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.