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 |
|
trusted4u
Posting Yak Master
109 Posts |
 Posted - 2003-04-20 : 03:30:09
|
| Hi:I have FinesDB with => 1 mdf in primary filegroup=> 3ndf's in secondary => and 1 ldf.While creating the tables and indexes I didn't mention the filegroup name. Now the question is, after the primary filegroup is full will sql server take up the secondary filegroup automatically ?Thanks- Marjo. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-04-20 : 07:23:03
|
| Filegroups do not get used unless you specifically put tables or indexes on them at creation time, or if you set a filegroup to be the default (primary is the default unless you change it). So the secondary filegroup won't have anything stored in it unless you've done either or both of these actions. |
 |
|
|
trusted4u
Posting Yak Master
109 Posts |
Posted - 2003-04-21 : 00:30:27
|
| Hi robvolk: Thanks for replying. According to what you said, it means that at present my secondary filegroup is empty bcoz neither it is a default filegroup nor I have placed any table or indexes in it. But then too, I would like to check for any table or indexes available in it, how do I do that ? and then if I delete the secondary will there be any problem ?Thanks,- Marjo. |
|
|
|
eversm
Starting Member
8 Posts |
Posted - 2003-04-21 : 11:39:42
|
| You can go into taskpad view on your database and you should see your primary and all secondary files. It will show you used space of your filegroups. I'm not sure how to find which tables are in the filegroup other than looking at the properties of the table. But if you have not put any tables into the filegroups they should show 0 MB used. I'm sure the system tables can be queried to list which objects reside in what filegroup, someone else in group may be able to help you with that! |
|
|
|
|
|
|
Need help On FileGroups