Post reply

Hi all

  • January 18, 2012 at 12:01 am

    #266717

    hai all.

    i have a query

    my database size is 500 gb .

    so in that how much size full backup it occupies , how much differential backup it occupies , and how much transaction log occupies..

    just let me know.. iam using 140 servers.

  • January 18, 2012 at 12:40 am

    #1435002

    I have a question for you.

    Did you face this question in an interview for SQL Server DBA position?

  • January 18, 2012 at 2:31 am

    #1435060

    YES..

    thats way i put this question in forum

  • January 18, 2012 at 3:56 am

    #1435100

    In short, the answers to your questions are:

    1) Not enough information

    2) Not enough information

    3) Not enough information

    A full backup will be the size of the data

    A differential backup will be the size of the changes since the last full backup

    A log backup will be the size of the log since the last log backup (except when in bulk-logged recovery model with minimally logged operations)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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