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 |
|
Faris2100
Starting Member
10 Posts |
 Posted - 2006-12-13 : 10:19:30
|
| Hello everyone,I have couple of questions, i would appreciate your thoughts and answers and examples.- How many log files are recommended for a DB?- do you have an example when you need to create more than one log file?- how do you keep the log file small for non critical DBs that don’t require the log to be backed up?Thanks |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-12-15 : 00:59:38
|
quote:
How many log files are recommended for a DB?
there is no hard n ship rule that states this, it depends on your rqiurement. quote:
do you have an example when you need to create more than one log file?
when i go 4 multiple datafiles quote:
how do you keep the log file small for non critical DBs that don’t require the log to be backed up?
if it is a non critical db i wld use simple recovery mode provided there is no need for at point time recoveryits me monty |
 |
|
|
Faris2100
Starting Member
10 Posts |
Posted - 2006-12-18 : 10:09:41
|
Thanks Monty for your answers. big help  |
|
|
|
|
|
|
SQL Admin