Tag Info

New answers tagged


A few notes here: You definetely have to separate the files logically using different partitions (I recommend separate partitions for: system, data files (mdf/ndf), transaction log files (ldf) and tempdb files (mdf/ndf). Where you put the tempdb transaction log file is up to you (tempdb drive or log drive), I'd go with log drive. Backup files should not be ...


The following SQL will show you which file groups your tables and indexes are in which will make it easy to see if there is data in any file group that shouldn't have data. SELECT f.[name] AS FileGroupName , o.[name] AS ObjectName , o.[type] AS [Type] , i.[name] AS IndexNAme , i.[index_id] AS IndexId ...

Top 50 recent answers are included