Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kish
Starting Member
45 Posts |
 Posted - 2004-03-01 : 00:53:49
|
| Hi All,Thanks for all the support till now.I need to populate a database and make it size go to 100 Gb, 500 GB and 1TB. We need this for testing purposes.What i have done made a table of 52 lac records and added index which gives that table a size of 400 MB.(data+index) and then I am doing 'select * into <new_table> from <existing_table> to quickly increase the DB size, and then create indexes as I have created for earlier table.Any other suggestions/thoughts on this.Thanks |
|
|
kish
Starting Member
45 Posts |
Posted - 2004-03-01 : 00:55:22
|
| also the recovery model is bulk logged, so the log file does not grow more than 8 MB for every new table created.which i am anyway truncating after every new table is created |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-01 : 13:07:18
|
| Why don't you just expand the MDF file?Tara |
|
|
|
kish
Starting Member
45 Posts |
Posted - 2004-03-01 : 23:53:16
|
| sorry...but i did not get what you are trying to suggest |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2004-03-02 : 00:18:24
|
| What Tara is saying is that you can make the DB file size as big as you want. There will be no data but the file system will not know the difference.....I suspect you want actual data volumes/size...BCP OUT the data you have now and then BCP IN .. It will grow at a stupid rate.... Repeat until disk implosion....DavidM"SQL-3 is an abomination.." |
|
|
|
kish
Starting Member
45 Posts |
Posted - 2004-03-02 : 23:15:20
|
| BCP and bulk insert are taking lot of time. "Select * into" is much faster than bulk loads. |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2004-03-02 : 23:19:51
|
| I find that incredibly hard to believe..DavidM"SQL-3 is an abomination.." |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-03-02 : 23:54:20
|
| Are you sure you turned on the SELECT INTO/BULK COPY option on your database? If that's off, bulk inserts will be logged and will take far longer. |
|
|
|
|
|
|
Big size DB