Results 1 to 4 of 4
Hi AHFB 2000! Forum: Introduce YourselfReplies: 0
Indian Travel website for $ 2000 Forum: Websites For SaleReplies: 0
Please help me with Access 2000!!!!! Forum: ASP ForumReplies: 1
Frontpage 2000 and CIW site designer exam Forum: HTML ForumReplies: 1
1st Page 2000 HTML Editor Forum: HTML ForumReplies: 1
10-23-2003, 10:14 AM #1
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)
10-23-2003, 12:41 PM #2
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 -
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?
10-24-2003, 10:09 AM #3
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!!
10-24-2003, 11:23 AM #4
Please report your results... im interested in knowing what you find.