Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    THAILAND
    Posts
    15

    Unanswered: SQL Server Back up

    Hi there.

    I'd like to backup below item from server to my client ( local ) .
    1. DTS package
    2. All jobs in SQL Server agent

    How can I do ?

    Please advise me
    1

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    All the DTS packages are stored in MSDB database and jobs as well.

    Take FULL backup of MSDB and copy the file to your local client, but do not attempt to restore which will ruin any jobs or DTS packages will not work if they specified to work on server.

    Review books online information oN MSDB.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Mar 2004
    Location
    THAILAND
    Posts
    15

    Thank you

    Originally posted by Satya
    All the DTS packages are stored in MSDB database and jobs as well.

    Take FULL backup of MSDB and copy the file to your local client, but do not attempt to restore which will ruin any jobs or DTS packages will not work if they specified to work on server.

    Review books online information oN MSDB.

    Thank you so much
    1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •