How much space to reserve from transaction logs

[TheJFM]

I am building a 250 Gb Win 2000 server. Raid 0 array.

There will be a single installation of SQL Server 2000.

It will not be a transactional system.

There will be a daily data push populating all the dBs and tables.

What is the best strategy?

A.A single 200 Gb drive for data file a transaction logs?

B.A large drive for data files and another for transaction logs. In this case how much space should I set aside for the trnasaction logs.

C. Another strategy


Thanks you all




** Don't reach for the moon when you have the stars. ;-) TheJFM **

 

[Corran007]

If it is all coming from a daily data push, then write speed isnt really that important. The main reason to seperate out the trans logs from the data files is to help increase performance with writes. Ill assume its an offhour datapush. id just stick them all together since it is not a transactional system.

 

[TheJFM]

Thanks. Thats kind of what I thought.

Just there are going to some update scripts running during the import process but for the rest of the time it will just be a datastore for querying

** Don't reach for the moon when you have the stars. ;-) TheJFM **