locked
How do you manage log database for multiple database's log? RRS feed

  • Question

  • User1215150307 posted

    How do you manage log database for multiple database's log?

    i always record the system name in log

    Thursday, October 6, 2011 4:25 AM

Answers

  • User-434868552 posted

    @ 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.

    g.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, October 12, 2011 6:54 PM