Re: Backup DTS and Jobs

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: songnetworks (nospam_at_spam.no)
Date: 11/02/04 

Date: 2 Nov 2004 10:38:47 +0200

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

Relevant Pages

  • Re: Restore DTS packages
    ... this database you can restore that. ... but instead of copying the msdb to a new location, ... > I have uninstalled a MSDE version but there were some DTS packages on it. ...
    (microsoft.public.sqlserver.dts)
  • Re: Backup DTS and Jobs
    ... > 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, ...
    (microsoft.public.sqlserver.server)
  • Re: Where are jobs and SP stored?
    ... Jobs and DTS packages are stored in msdb database. ... I want to backup all my sql jobs, DTS, SP and I don't know which table i ...
    (microsoft.public.sqlserver.server)
  • Detaching database - what will happen to DTS and jobs?
    ... What will happen to all DTS packages and jobs which use this ... database when I detach it - will the database name disappear from all ...
    (microsoft.public.sqlserver.dts)
  • Re: Unload Event Problem
    ... come up with that will allow the database to be used as it is now. ... working so they validly have records with no StopTime yet, ... the jobs relating to the user who is closing down. ... The unload event on the hidden form with null StopTime forcing user to ...
    (microsoft.public.access.forms)