Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alejo46
Posting Yak Master
157 Posts |
 Posted - 2013-08-03 : 11:52:10
|
| Good morning:i've got 2 questions:1. is there any way to identify the path or drives in which a specific filegroup is stored in SQL 2K or i have to script?for instance the datafiles for the primary or secondary FGs DATA5 are stored in:D:\Traficoall\TRAFICO1_Data.ndfF:\Hetrlldasmsc2_2\Hetrlldasmsc2_2.NDF2 the following script works OK in sql 2008k and prints out DatabaseFileName|FileSizeInMB|FileGroupName|DatabaseFilePath but not in 2000K, is there anyway to apply the same script for 2000K using different system tables adding free space field ? SELECTdbfile.name AS DatabaseFileName,dbfile.size/128 AS FileSizeInMB,sysFG.name AS FileGroupName,dbfile.physical_name AS DatabaseFilePathFROMsys.database_files AS dbfileINNER JOINsys.filegroups AS sysFGONdbfile.data_space_id = sysFG.data_space_idI'd appreciate your help in advanced |
|
|
|
|
|
check the path or drives for a filegroup