Home Forums SQL Server 2008 SQL Server 2008 - General Estimate Backup Size before backup strat RE: Estimate Backup Size before backup strat

  • October 22, 2012 at 12:18 am

    #1551236

    thirudwh (10/21/2012)

    Experts,

    I am new to SQL Server,i have requirement to run backup using stored procedure.

    I am using a stored procedure to call backup command,before backup need to include a step to estimate backup size and compare with disk available space size.If enough space available on the drive then only my backup need to kickoff else terminate process.

    How to estimate backup size and compare with Disk within same stored procedure ?

    Thanks in Advance.

    though this can be acheived by multiple scripts btu still there should be proper capacity planning (proactive approach) to do this

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)