patternsqlMinor
SQL Server 2008 R2 Log File Location
Viewed 0 times
file2008logsqlserverlocation
Problem
One of the databases I am going to support does not have a validate log file location. The drive which the log file is pointing to does not exist. But I don't see any error in database error log because of this.
Is there a default location for SQL server log file when the log file path is not set right?
Thanks
Is there a default location for SQL server log file when the log file path is not set right?
Thanks
Solution
If you go to server properties, in the database settings, you will find the default database data, log and backup locations :
Context
StackExchange Database Administrators Q#77510, answer score: 3
Revisions (0)
No revisions yet.