Scheduled Backups

I have setup several backup sets via the individual database.
But - in SQL Server 2000 - my brain has faded away. I can't find where to
access those scheduled backups that I setup?
Can anyone help me find where to change scheduled backup times? I am sure
it's right in front of my face, and I am just missing it.
Thanks
Kevin
Hi,
1. Open SQl Server Enterprise manager
2. Expand the server you need to change the backup job timings
3. Go to "Management" Option
4. Expand " SQL Server Agent"
5. Select "Jobs"
6. Now in the right side of window pane all the jobs will be displayed.
7. Double click on ur job , select the schedules , click EDIT and change the
timings
8. Click OK and APPLY.
Thanks
Hari
MCDBA
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>
|||Hi,
1. Open SQl Server Enterprise manager
2. Expand the server you need to change the backup job timings
3. Go to "Management" Option
4. Expand " SQL Server Agent"
5. Select "Jobs"
6. Now in the right side of window pane all the jobs will be displayed.
7. Double click on ur job , select the schedules , click EDIT and change the
timings
8. Click OK and APPLY.
Thanks
Hari
MCDBA
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>
|||Using Enterprise Manager
your server > Management > SQL Server Agent > Jobs
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>
|||Using Enterprise Manager
your server > Management > SQL Server Agent > Jobs
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Kevin Hill" <khill@.nospam.com> wrote in message
news:6o5Ec.791$T05.626@.chiapp18.algx.net...
> I have setup several backup sets via the individual database.
> But - in SQL Server 2000 - my brain has faded away. I can't find where to
> access those scheduled backups that I setup?
> Can anyone help me find where to change scheduled backup times? I am sure
> it's right in front of my face, and I am just missing it.
> Thanks
> Kevin
>