SQL Server Log File Location

Posted on 2011-05-10
Last Modified: 2012-05-11

How would I find where a scheluded integrity check log file .ldf is stored in SQL Server 2005. Screenshots would be most helpful thank you.

Thank you

Question by:hellworld12345
    LVL 22

    Expert Comment

    by:Om Prakash
    to find the location of log file, run the following query:
    SELECT name, physical_name AS current_file_location FROM sys.master_files


    Author Comment

    That helps but how would I find the log file of specific scheduled task i.e. backup, intergrity, optimization.

    Thank you.

    Author Comment

    By scheduled task I mean a task that appears in the SQL server agents > Jobs area.

    Thank you.
    LVL 21

    Accepted Solution


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now