Create a database with data

[steveot]

Im not a SQL person but is there any script or something that can be run to create a 10 gig or 20 gig database filed with bogus information. Just something to represent a database that large. I dont care it its all 1's and 0's.

 

[maswien]

Ok, you can do that in following way,

open Enterprise manager, create a new job

this job run following SQL on pubs database

insert into sales select * from sales

schedule this job running every minutes, after while you will get a big pubs database.

 

[maswien]

Don't forget disable the job when the database get to a satisfactory size. Also you need set the recovery mode to 'simple' and shrink the database at the end using following command :

dbcc shrinkdatabase('pubs', 10)


let me know what you get.