Zack
asked on
SQL Server Log File Location
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
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
ASKER
That helps but how would I find the log file of specific scheduled task i.e. backup, intergrity, optimization.
Thank you.
Thank you.
ASKER
By scheduled task I mean a task that appears in the SQL server agents > Jobs area.
Thank you.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SELECT name, physical_name AS current_file_location FROM sys.master_files