Results 1 to 3 of 3

Thread: Backup

  1. #1
    Join Date
    May 2003
    Location
    Chennai , India
    Posts
    2

    Unanswered: Backup

    If a 250 MB database contains only 30 MB of data, how much of the database is written when the database is backed up? Why?
    a. 30 MB
    b. 250 MB
    c. 220 MB
    d. 60 MB

  2. #2
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110

    Re: Backup

    If you have a 250Mb Db which only contains 30Mb of data. Then the backup should be around the 30Mb mark give or take.

    A database being 250Mb in size, most likely would include data, transaction log and unused space. Your transaction log is not included in a full database dump. And the space allocated to your db which is not currently filled with data is also not backed up.

    I'm sure the answer also depends on your version of SQL Server as well. Does this answer your question?


    Originally posted by ssivaprasad
    If a 250 MB database contains only 30 MB of data, how much of the database is written when the database is backed up? Why?
    a. 30 MB
    b. 250 MB
    c. 220 MB
    d. 60 MB

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Valid explanation by Bmalar, looks like you(siva) struck with one of questions from certifications.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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