Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Location
    Reading, UK
    Posts
    70

    Unanswered: Is this a bug in sql server 2005??

    Its with "is-percent-growth" parameter of the sys.database_files table.

    We had one of our client database with the file-percent growth as 64000, when I tried to update it, it throws an error message, I was wondering how did sql server accept such a huge value.(Can be modified using alter db stmt)
    Tested in the test environment
    database had values (growth was 500MB 500*128)
    name size growth is-percent-growth
    DESIGN_Data 655360 64000 0
    DESIGN_Log 21808 10 1

    When restored the above db to a new db the new db has the below values:
    name size growth is-percent-growth
    DESIGN_Data 655360 64000 1
    DESIGN_Log 21808 10 1

    which leaves the file-growth as 64000 percent.

    Hope, this is a bug when the growth size is high then the restored DB will have a huge growth % and when the turn to autogrow comes??cause perf issues.

    Pavan.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi

    I have no idea but I imagine some people might want version incl service packs.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Sorry - missed the title. SP still though...
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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