Post reply

If we pass the DB name paramter should take the backup in the same server

  • June 24, 2019 at 1:32 pm

    #3656949

    I guess that your question is how do you check the space remaining on the drive?  Try using the stored procedure xp_fixeddrives.

    John

  • June 24, 2019 at 7:33 pm

    #3657088

    It really isn't a good idea to put backups on the same drive/location as your data/log files.  Not only will that cause performance issues - but if you lose that drive you also lose the ability to restore.

    You can also query the backup directory location defined for that instance using xp_instance_regread.  This will identify the location defined in the GUI for you - so you can then determine the rest of the path (if needed).

    As for checking the space available - I would create a separate monitoring process using a powershell script and set that as the first job step in the agent job.  You need to be able to figure out how large a typical backup file will be - and then see if there is enough space available...or, you check the available space and notify when the space available drops below a certain percentage of the drive space.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • June 27, 2019 at 11:22 am

    #3658040

    Thanks Jhon and Jeffrey. I will check the backup directory location defined for that instance using xp_instance_regread.

     

    I will try for the same and will update you.

     

    Thanks once again.

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

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