Results 1 to 5 of 5
  1. #1
    Join Date
    May 2004
    Posts
    7

    Unanswered: user needs old jobs

    I have a user who needs the text SQL commands she put into a job on an old server last year. The job does not have to run, she just needs the many SQL commands she used in every step of the job. Sorry if this is a dumb question but... Can I get this back by restoring the old vintage master database into a new unused SQL server (created just for this).

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Your use of the term "job" makes me think you are using SQL 7.0 or later. If that is the case, you'll need msdb instead of master.

    -PatP

  3. #3
    Join Date
    May 2004
    Posts
    7
    Thanks Pat. This is in fact SQL server 2000 and you're correct. I've never had to do this before, so I'm not sure exactly what I'm doing yet. Are you saying I'll need to restore MSDB only, and not master ? I'm trying to find some reading on this right now. Thanks again.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Yes, the general overview is:

    1) Backup today's msdb so you can restore it later
    2) Restore the old msdb
    3) Retrieve whatever data you need from it. Scripting works well for this.
    4) Restore the backup from step 1 ASAP.

    You don't need to touch master at all.

    -PatP

  5. #5
    Join Date
    May 2004
    Posts
    7
    Excellent. Thanks for the reassurance Pat.

Posting Permissions

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