In this tip I explain how to make sure that you have only one database transaction log file and more than one data file using policy based management.
Please read this MSSQL Tip: “Using Policy Based Management for checking SQL Server database file extensions“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.