Home » Blog » Topic » SQL Server log file not accessible, dbcc not really useful, how to analyze?

SQL Server log file not accessible, dbcc not really useful, how to analyze?

Andrew Jackson ~ Modified: September 16th, 2015 ~ ~ 1 Minute Reading

Home › Forums › SQL Server log file not accessible, dbcc not really useful, how to analyze?

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • September 16, 2015 at 1:12 pm #671 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    I’m trying to track down why a db query got screwed in SQL Server.
    dbcc log(mydb,2) is not filterable by date(?). And the ldf file I can’t access directly without going through 2 layers of bureaucracy
    Any suggestion? How to tackle with it?

    September 19, 2015 at 10:27 am #679 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    What do you mean by “query got screwed”? Could you provide the available resource?

    September 21, 2015 at 12:35 pm #702 Score: 0
    Stephen West
    Moderator
    4 pts

    not sure, I know when stored proc was called, from my webserver log, now trying to track it down on db logs.

    September 22, 2015 at 12:17 pm #711 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    I got the solution by applying SELECT * FROM fn_dblog(null,null)

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.