HOw do I make a SQL database --30GB ?

We need to make a 30 GB SQL database that is going to be tested on our
fibre drives. Please point us in the right direction. Is there anyway
to generated SQL databases of any size? Thanks for your helpYou mean anyway besides the CREATE DATABASE command, which is
documented in Books Online? Create any database you like, any size,
with various options for automatic growth.
naijababy wrote:
> We need to make a 30 GB SQL database that is going to be tested on our
> fibre drives. Please point us in the right direction. Is there anyway
> to generated SQL databases of any size? Thanks for your help|||Hi
You can create an empty database of 30GB using the TSQL create datebase
command and specifying the size as being 30GB. What you are probably going to
need is data that you can use in a benchmark. This will probably depend on
what tool you are going to use to perform the benchmark such as LoadRunner
http://www.mercury.com/us/products/performance-center/loadrunner/
or IBM Rational performance tester
http://www-306.ibm.com/software/awdtools/tester/performance/index.html or
Benchmark factory from Quest
http://www.quest.com/benchmark_factory/default.aspx. You may also want to
look at the free SQLIOStress tool if you just want to test the disc
subsystem http://support.microsoft.com/kb/231619
John
"naijababy" wrote:
> We need to make a 30 GB SQL database that is going to be tested on our
> fibre drives. Please point us in the right direction. Is there anyway
> to generated SQL databases of any size? Thanks for your help
>