Thursday, March 22, 2012

Backup DTS and Jobs

Hi!
When I backup my database, how can I include DTS and Jobs?
Thanks!
/Tom Hansen> When I backup my database, how can I include DTS and Jobs?
Jobs are in msdb daabase. If you save DTS packages to SQL Server, they are
in the msdb database as well. So simply backup the msdb database.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Thanks a lot!!
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OJbtN4LwEHA.1300@.TK2MSFTNGP14.phx.gbl...
>> When I backup my database, how can I include DTS and Jobs?
> Jobs are in msdb daabase. If you save DTS packages to SQL Server, they are
> in the msdb database as well. So simply backup the msdb database.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>

No comments:

Post a Comment