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 |
|
biranchi.mohapatra
Starting Member
6 Posts |
 Posted - 2010-09-24 : 12:49:58
|
| Hi,In production server if we are creating a database which size is 100 gb then how many data file and log file should be there.Best Regards,Biranchi |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
biranchi.mohapatra
Starting Member
6 Posts |
Posted - 2010-09-24 : 13:18:10
|
| Thanks Tara for your prompt response.Regards,Biranchi |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
backup
You only ever need one log file. Multiple log files is used in case you run out of space in one drive and can rollover to another drive.Tara Kizer