A blog about SQL Server, SSIS, C# and whatever else I happen to be dealing with in my professional life.

Find ramblings

Monday, September 21, 2009

Dude, where's my database?

Ultra-brief post today.

If you need to know what physical file(s) are associated with what
databases, then sys.master_files is the view for you.
http://msdn.microsoft.com/en-us/library/ms186782.aspx Plenty of handy
information there but physical_name is where you can determine what
mdf file(s) a database is using and where they are located on the file

No comments: