SQL Server Log....

  • Hi

    I'm very novice when it comes to SQL Server Administration. 

    I have been asked if the SQL Server Log can trace information on whether data supplied to an individual has been tampered with, or if it is the full data set provided.

    Apologies for this vague description, but that is what I have to go on also.

    I am trying to find an article which details what the purpose of SQL Server logs are and if I can extract this sort of information from them.

    Any idea if the SQL server log can provide tracing/editing/exporting information? 

    Thanks!!

  • SQL Server information will have information like when the sql server has started, recovery of databases, any user or system errors, backup of databases, restorations, dbcc commands, login informations and lot more. You can also make sql server to log few activities it perfoms choosing the log option.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply