Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2011
    Posts
    2

    Unanswered: recover data from msdb database

    Hi all,

    I have an mdf, ldf of masdb database. it has jobs wriiten to it. I have been trying to attach the same but not working fine. can any one plz guide me as to how to attach this db / get my job scripts

  2. #2
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250

  3. #3
    Join Date
    Oct 2011
    Posts
    29
    Quote Originally Posted by shoab.shah View Post
    Hi all,

    I have an mdf, ldf of masdb database. it has jobs wriiten to it. I have been trying to attach the same but not working fine. can any one plz guide me as to how to attach this db / get my job scripts
    msdb is a system database. If you sql instance is already running, it must have msdb database already.

    You can attach the older msdb in a different name and then pull out information from it.

Tags for this Thread

Posting Permissions

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