Friday, March 9, 2012

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
KevinHi,
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
>

No comments:

Post a Comment