?
Solved

SQL Server Log File Location

Posted on 2011-05-10
4
Medium Priority
?
276 Views
Last Modified: 2012-05-11
Heyas,

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

0
Comment
Question by:Zack
  • 2
4 Comments
 
LVL 22

Expert Comment

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

0
 

Author Comment

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

Thank you.
0
 

Author Comment

by:Zack
ID: 35735233
By scheduled task I mean a task that appears in the SQL server agents > Jobs area.

Thank you.
0
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 200 total points
ID: 35736063
image
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Screencast - Getting to Know the Pipeline

850 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