Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2008
    Posts
    46

    Unanswered: how to find modified db size

    hello every one,
    I have a multiple databases (20-30) in a server, each db has more than 100 g space and too many tables. I have database backup script on schedule.

    I wan to backup thoes db which are not change. I mean some db does not record effect. I try to find out db size using sp_spaceused i get the db size. But when i try to manualy enter a record in a single table and execute sp_spaceused, i don't see the different of db size. If i check table's row count i do.....but it is not possible to check all the table (each db has more than 50-60 table) and db.

    Any body know how to find the different db size.....if that db has change only one record (insert/edit/del)

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    This goes into database internals. Read up on Pages in BoL for a more thorough explanation.

    In short, adding data to a table does not necessarily result in more space being "used" as you have found.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    If you only want to backup changes, you could read up on differential backups.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Oct 2008
    Posts
    46
    Thanks Pootle for quick response.
    Still i do not get the right solution

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    So you understand differential backups and these don't work for you? In what way do they not meet your requirements?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  6. #6
    Join Date
    Oct 2008
    Posts
    46
    yes i do the diff backup too......
    i have three option backup on my stored procedured. Full, Diff and Log

    Every week i have to full backup.

Posting Permissions

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