HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

SQL Server 2008 R2 Log File Location

Submitted by: @import:stackexchange-dba··
0
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

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.