Last post Oct 12, 2011 06:54 PM by gerrylowry
Oct 06, 2011 04:25 AM|Fitmation|LINK
How do you manage log database for multiple database's log?
i always record the system name in log
Oct 12, 2011 06:54 PM|gerrylowry|LINK
@ Fitmation TIMTOWTDI =. there is more than one way to do it
depends on many factors.
example: if your are hosting competing customers who are using a similar system, then it would be wise not to mix their data in a single log database.
if multiple drives are available, I'd probably keep the log database on a separate drive.
N.B.: rather than recording the system name, unless it was short, i'd probably use an int or a single character to avoid lots of unnecessary bytes, especially if the number of log records is huge.
it's important to consider the pros and cons of combining logs; each case needs to be treated on its own merits.