Im guessings there isnt a definate answer to this. Im also guessing weather the DB is OLAP or OLTP would effect.
We have a database that is currently 14gb for the .mdf and 15gb for the .ldf is that right? I read that the log files could grow if a transaction is never closed?
the database is in full recovery mode we do full backsup every night, diff every 3 hours during work ours and then 30 mins for tlogs.
None of the other database we have run this high (Tlogs reach this size). Im just wondering if there is a problem and how would i find out if there was/fix it?
thanks for any input.