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.ndf
F:\Hetrlldasmsc2_2\Hetrlldasmsc2_2.NDF
2 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 ?
SELECT
dbfile.name AS DatabaseFileName,
dbfile.size/128 AS FileSizeInMB,
sysFG.name AS FileGroupName,
dbfile.physical_name AS DatabaseFilePath
FROM
sys.database_files AS dbfile
INNER JOIN
sys.filegroups AS sysFG
ON
dbfile.data_space_id = sysFG.data_space_id
I'd appreciate your help in advanced
|
|
|
|
|
|
check the path or drives for a filegroup