Results 1 to 4 of 4

Thread: Database Size Growth

  1. 09-23-2002, 08:59 PM #1
    sbawa
    sbawa is offline Registered User
    Join Date
    Sep 2002
    Posts
    11

    Angry Database Size Growth

    I am somewhat confused -- I have a database in production that I restored to a QA environment; upon restore, the size has grown by 200MB.

    Both production and QA are running SQL2000 -- the only difference is that QA has the latest security hotfixes installed -- version 8.0.0.665 from KB article at the following link:

    Q316333
    Reply With Quote Reply With Quote
  2. 09-24-2002, 07:45 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Do you use same block size for disks on both server? Did you check data and log size to see which portion got size increased?
    Reply With Quote Reply With Quote
  3. 09-24-2002, 10:44 AM #3
    sbawa
    sbawa is offline Registered User
    Join Date
    Sep 2002
    Posts
    11
    How do I check the current block size; is this the same as allocation unit size specified while formating a logical drive??

    thanks for the help
    Reply With Quote Reply With Quote
  4. 09-24-2002, 10:54 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Yes. If you have raid array, you can check it with array config tool.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules