Filegroups and physical files

Hello All,
I am trying to analyse a DB schema created by someone
else. There is a file groups. How can I find out how many
files (and on what drives) belong to that file group?
Thanks a lot in advance for your help.
regards,
Abhishek.Hi,
If you are using enterprise manager right click on the database and look at
the properties.
From TSQL do this
select * from master.dbo.sysaltfiles
--
I hope this helps
regards
Greg O MCSD
SQL Scribe Documentation Builder
Document any SQL server database in minutes
Programmers love it, DBA dream of it
AGS SQL Scribe download a 30 day trial today
http://www.ag-software.com/ags_scribe_index.asp
"Abhishek Srivastava" <abhishek@.nospam.net> wrote in message
news:085701c345d8$7178cae0$a301280a@.phx.gbl...
> Hello All,
> I am trying to analyse a DB schema created by someone
> else. There is a file groups. How can I find out how many
> files (and on what drives) belong to that file group?
> Thanks a lot in advance for your help.
> regards,
> Abhishek.|||You can list all database files along with the file group name with
sp_helpdb:
EXEC sp_helpdb 'MyDatabase'
You can list files in a specific file group with sp_helpfilegroup:
USE MyDatabase
EXEC sp_helpfilegroup 'PRIMARY'
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Abhishek Srivastava" <abhishek@.nospam.net> wrote in message
news:085701c345d8$7178cae0$a301280a@.phx.gbl...
> Hello All,
> I am trying to analyse a DB schema created by someone
> else. There is a file groups. How can I find out how many
> files (and on what drives) belong to that file group?
> Thanks a lot in advance for your help.
> regards,
> Abhishek.