attach file + physical location

attach and physical loc .sql

--atach file
CREATE DATABASE [SchoolDB] ON 
( FILENAME = N'D:\SchoolDB.mdf' ),
( FILENAME = N'c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SchoolDB_log.ldf' )
 FOR ATTACH
GO

--attach file
create database SchoolDB ON
( filename = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\SchoolDB.mdf')
for attach
go


-- know the physical files of db
SELECT SUBSTRING(physical_name, 1, CHARINDEX(N'master.mdf', LOWER(physical_name)) - 1)
                  FROM master.sys.master_files
                  WHERE database_id = 1 AND file_id = 1