|
Home > Archive > MS SQL Server > December 2005 > how to find which object belongs to which File group
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
how to find which object belongs to which File group
|
|
|
| Hi
We have a DB in which we have created two file groups. Both are currently
Primary file group. what is the best way to find out which objects are in
which file group?
Thanks,
| |
| Tom Moreau 2005-12-12, 8:23 pm |
| This doesn't make sense. "Both are currently Primary file group." Only one
filegroup can be the primary filegroup.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@cips.ca
www.pinpub.com
"Moh" <mabbas@Pier1.com> wrote in message
news:B93809BB-695B-4EED-9CE0- B3154B7D8301@microso
ft.com...
> Hi
> We have a DB in which we have created two file groups. Both are currently
> Primary file group. what is the best way to find out which objects are in
> which file group?
>
> Thanks,
>
>
| |
|
| I can mail you screen shot of EM where two files are listed as primary file
groups.
Moh
"Tom Moreau" wrote:
> This doesn't make sense. "Both are currently Primary file group." Only one
> filegroup can be the primary filegroup.
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada tom@cips.ca
> www.pinpub.com
>
> "Moh" <mabbas@Pier1.com> wrote in message
> news:B93809BB-695B-4EED-9CE0- B3154B7D8301@microso
ft.com...
>
>
>
| |
| Tom Moreau 2005-12-12, 8:23 pm |
| That's not what you said. You said "we have created two file groups". Now,
you're saying you created two files. Which is it?
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@cips.ca
www.pinpub.com
"Moh" <mabbas@Pier1.com> wrote in message
news:A0603CAB-EDF1-46BF-B449- D989432DF7DF@microso
ft.com...[color=darkred]
>I can mail you screen shot of EM where two files are listed as primary file
> groups.
>
> Moh
>
> "Tom Moreau" wrote:
>
| |
|
| By the way for your knowledge, you can have more than one files belongs to a
File group(Primary FG or any other). you can not have one file belongs to
more than one FG.
Does that mamke sense?
thx,
Moh
--
Sr DBA
Pier 1 Imports
mabbas@Pier1.com
"Tom Moreau" wrote:
> This doesn't make sense. "Both are currently Primary file group." Only one
> filegroup can be the primary filegroup.
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada tom@cips.ca
> www.pinpub.com
>
> "Moh" <mabbas@Pier1.com> wrote in message
> news:B93809BB-695B-4EED-9CE0- B3154B7D8301@microso
ft.com...
>
>
>
| |
| Tom Moreau 2005-12-12, 8:23 pm |
| I'm already aware of that. So, what exactly is the problem?
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@cips.ca
www.pinpub.com
"Moh" <mabbas@Pier1.com> wrote in message
news:D6BCED88-53DB-4DA8-BC41- 00E355065EF0@microso
ft.com...[color=darkred]
> By the way for your knowledge, you can have more than one files belongs to
> a
> File group(Primary FG or any other). you can not have one file belongs to
> more than one FG.
> Does that mamke sense?
> thx,
> Moh
> --
> Sr DBA
> Pier 1 Imports
> mabbas@Pier1.com
>
>
> "Tom Moreau" wrote:
>
| |
| Med Bouchenafa 2005-12-12, 8:23 pm |
| a filegroup is composed of one or more files
Objects are placed on filegroups and not files
If you wanted to know on which filegroup an object is placed, use sp_help
@objectname
or the undocumented sp_objectfilegroup @objid
If you wanted to know the list of all objects that belong to a filegroup
you can query sysindexes and group by the result by groupid
--
Med Bouchenafa
"Moh" <mabbas@Pier1.com> a écrit dans le message de news:
B93809BB-695B-4EED-9CE0- B3154B7D8301@microso
ft.com...
> Hi
> We have a DB in which we have created two file groups. Both are currently
> Primary file group. what is the best way to find out which objects are in
> which file group?
>
> Thanks,
>
>
| |
| Absar Ahmad 2005-12-14, 9:23 am |
| Dear M Abbas,
From your 3 posts in this Response, it is clear that you need to improve in
following areas:
1. English Language Skills: There are both grammatical as well as spelling
mistakes in your posts. Example of Grammatical Mistake: ‘Both are currently
Primary file group’. Example of Spelling Mistake: ‘….mamke sense’.
2. Behavioural Skills: Tom Moreau didn’t make any wrong statements. It is
you who made wrong statement in the 1st post by saying ‘…we have created two
file groups. Both are currently Primary file group’. Still, you have
expressed anger in your 3rd post.
3. SQL Server Skills.
Remember, that the first person to benefit from these improvements will be
you. So choice is yours.
"Moh" wrote:
[color=darkred]
> By the way for your knowledge, you can have more than one files belongs to a
> File group(Primary FG or any other). you can not have one file belongs to
> more than one FG.
> Does that mamke sense?
> thx,
> Moh
> --
> Sr DBA
> Pier 1 Imports
> mabbas@Pier1.com
>
>
> "Tom Moreau" wrote:
>
|
|
|
|
|