Post reply

Maintance Plan Backup Location

  • October 20, 2005 at 1:58 am

    #110672

    FROM WHERE WE CAN GET THE MAINTAINCE PLAN DB BACK AND TRAN LOG BACKUO LOCATION.

    SCENE:

    WE HAVE AROUND 10 DATABASE AND MANY MAINTANCE PLANS FOR THE BACKUP AND TRANSACTION LOG BACKUP.

    I WROTE SCRIPT TO GET THE WHAT KIND OF BACKUP IS HAPPENING AT REPECTIVE DATABASE BUT I AM NOT GETTING WHERE IS (LOCATION OR PATH)

    BACKUPS ARE HAPPENING (HINT: WHEN WE CREATE MAINTAINCE PLAN WE SELECT PATH FOR BACKUP,I NEED THAT LOCATION THROUGH SCRIPTS).

    I NEED WHICH SYSTEM TABLE WILL HAVE THE LOCATION OF THE MAINTAINCE PLANS)

    THANKS

  • October 20, 2005 at 7:07 am

    #598680

    The location plan is stored in MSDB. You can view it in Enterprise Manager>Management>Jobs.

    -SQLBill

  • October 20, 2005 at 9:58 pm

    #599007

    Hi ,

    Here is the query. i need backup location for the same.

    use master

    select --A.Plan_id,B.Job_Id

    A.Database_Name,C.Name

    from sysdbmaintplan_databases A , sysdbmaintplan_jobs B , sysjobs C

    where A.Plan_Id = B.Plan_Id

    and C.job_id = B.job_id

    order by Database_Name,Name

  • October 21, 2005 at 3:06 am

    #599038

    You can get this info from the "command" column of "sysjobsteps" table

    Jayesh

  • October 21, 2005 at 5:42 am

    #599069

    Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply