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 |
|
poratips
Posting Yak Master
105 Posts |
 Posted - 2013-08-19 : 14:57:56
|
| Hi,I have to restore DB into New Production server 2008 and we have 2008R2 installed.I would like to know what will be the ideal setting for Log file set up?I have Data File, Log File and Temp DB on seperate Disk drive.I have set up the Data File Initial Size: 100 GB - Growth - 5 GB as total Daat File Drive has 1 TB Capacity.I am little confused for Log file as We have Replication Subscription will be running on that DB and it will total size of the DB is 300 GB Plus.Replication will run frequently as well as couple batch job running.If I set up Log File: 50 GB - Growth - 1 GB as my total Log file drive is configured - 100 GB.Thanks and appreciate your response! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
poratips
Posting Yak Master
105 Posts |
Posted - 2013-08-19 : 18:19:43
|
| Thanks Tara.Our Replication runs frequently, weare not runnign Index Rebuild regularly but planning to run as a weekly job.If you can give some rough idea to start that will be great.If I set up Log File: 50 GB - Growth - 1 GB as my total Log file drive is configured - 100 GB, will impact any performance?Thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Log File Size Set up in Sql 2008