48 users online (1 members and 47 guests)  


  Results 1 to 4 of 4

Related

  1. Hi AHFB 2000!    Forum: Introduce Yourself
    Replies: 0
  2. Indian Travel website for $ 2000    Forum: Websites For Sale
    Replies: 0
  3. Please help me with Access 2000!!!!!    Forum: ASP Forum
    Replies: 1
  4. Replies: 1
  5. 1st Page 2000 HTML Editor    Forum: HTML Forum
    Replies: 1
  1. #1
    marcop300's Avatar
    New User

    Status
    Offline
    Join Date
    Oct 2003
    Location
    USA
    Posts
    2

    Unhappy building a 300GB test DB (SQL 2000)

    Let me give you an Idea on why I want to do this. I would like to see how fast a can backup a SQL DB to disk.

    Example: I want to have a Test Db that is around 300-400GB in size.

    Then I would test on doing a backup to disk by using one drive letter. That drive letter would be 1TB in size.

    then I want to do another test on backing up the same DB across 3 drive letters (that are 333GB each that total the same as the one drive letter above (1TB)).


    I have a 350GB DB built now (using W2k and SQL2K (SP3). But it is empty. I would like to find a util that is SIMPLE to use that will FILL up my DB to about 349_+ GB.

    Do you all know of anything?

    Thanks and sorry is this is the wrong forum... but reading over this site looks like there is some smart folks on here.

    Mr. Newbie :O)

  2. #2
    QuietDean's Avatar
    Administrator

    Status
    Offline
    Join Date
    Oct 2000
    Location
    Bournemouth, UK
    Posts
    2,662

    Re: building a 300GB test DB (SQL 2000)

    Simplest would be to -

    1) Build a large-ish insert in Enterprise Manager
    2) Export the insert to a file ( insert.sql for example)
    3) Create a batch file to loop -
    Code:
    Call \sqldir\insert.sql
    and leave it looping!

    The only bit I am unsure of is looping in a batch file (I am a unix bod, not a windows wizard ) so maybe someone else will come up with an idea for that.
    If one of our members helps you, please click the icon to add to their reputation!
    No support via email or private message - use the forums!
    Before you ask, have you Searched?

  3. #3
    marcop300's Avatar
    New User

    Status
    Offline
    Join Date
    Oct 2003
    Location
    USA
    Posts
    2
    Thanks QuiteDean for helping..

    I found a fix... What I'm using to build my DB is Microsoft Sql Server TPC-C Benchmark Kit ver 4.41

    It works like a champ!!

  4. #4
    Zaire's Avatar
    Senior Member

    Status
    Offline
    Join Date
    Mar 2001
    Location
    Hamburg, NY
    Posts
    312
    Please report your results... im interested in knowing what you find.



Tags for this Thread