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 |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2009-01-16 : 04:46:34
|
| Hi everyone, can any one tell me how to create scheduled jobs(hourly,differiental backups,log backups)in sqlserver2005. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-16 : 06:11:06
|
quote:
Originally posted by DBA007
Hi everyone, can any one tell me how to create scheduled jobs(hourly,differiental backups,log backups)in sqlserver2005.
I use Maintenance plan for it. |
 |
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2009-01-16 : 08:20:43
|
| Thanks for the replies,but can you tell me how to create different types of Maintenance Plans. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-16 : 10:15:32
|
quote:
Originally posted by DBA007
Thanks for the replies,but can you tell me how to create different types of Maintenance Plans.
We have separate maintenance plans for each type of backup.Booksonline has details. |
|
|
|
|
|
|
scheduled jobs