Implementing Physical Database Structure - Microsoft SQL Server 2012 Performance Tuning - page 334

13. To locate the log file, click on the … button in the Current File Path column for the
AdventureWorks2012_log.ldf log file. This will bring up the Locate Database Files
dialog box. Locate the file L:\SQL_Log\AdventureWorks2012_log.ldf and click on
the OK button. Refer to the following screenshot:
14. To verify the new location of the AdventureWorks2012 database, run the following
query in SSMS:
--Switch the current database
--context to AdventureWorks2012
USE AdventureWorks2012
GO
--Verify the new location of
--the database.
SELECT
physical_name
,name
FROM sys.database_files
GO