| Author |
Topic |
|
loiter99
Starting Member
38 Posts |
 Posted - 2004-03-05 : 08:22:43
|
| What happens when an .NDF file fills up?I have 3 NDF files and #2 is 100% full. Will this cause harm to the DB integrity?Thanks in advance. |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-05 : 08:35:32
|
| DB Integrity isn't an issue, you will however encounter problems when the other data files fill up as well. SQL Server tries to spread write activity across all available data files until they are all full at which point it will try to auto-grow files that have that property set. Do any of your files have auto-grow on?Raymond |
 |
|
|
loiter99
Starting Member
38 Posts |
Posted - 2004-03-05 : 08:42:53
|
| Yes, the last NDF in the bunch is the only one set to auto-grow. So, once the limit has been reached, the NDF just sits there doing nothing buy holding it's chuck of the DB?Is that wise? Does that defeat the purpose of using NDF's ? |
|
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-05 : 08:45:02
|
| Are the NDFs on different physical disk drives? Or different filegroups? Why are you using multiple NDFs?Raymond |
|
|
|
loiter99
Starting Member
38 Posts |
Posted - 2004-03-05 : 09:00:07
|
| The MDF is on one drive, the NDF's are on a separate drive.I actually didn't configure this setup, I am picking up for another person and I am trying to figure out why it was done this way.It just seems odd to have all but one NDF grow automatically.How can I tell if their are file groups set up in the NDF's?Thx |
|
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-05 : 10:02:51
|
| Use sp_HelpFile in QA with the database selected. It will list attributes for every file in the database, including the Filegroup.Raymond |
|
|
|
loiter99
Starting Member
38 Posts |
Posted - 2004-03-05 : 10:38:01
|
| Thanks, No file groups, all primary. Why would the person set up NDF files to grow to 100 Mgs and then stop? Odd.Thanks |
|
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-05 : 10:39:36
|
| And are all the physical files on the same drive? If so then there's little point in having multiple NDFs!Raymond |
|
|
|
loiter99
Starting Member
38 Posts |
Posted - 2004-03-05 : 10:50:03
|
| Well, the primary is on one drive and the NDF's are on a second drive.Still, I don't see the point .. but I am sure I am missing something. Why not just have one NDF and have it grow. What is the point of 3 other NDF's that stop growing at 100 Mgs. Could it have been for backup reasons? |
|
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-05 : 11:06:57
|
| Perhaps. You can backup files as well as filegroups using the BACKUP command.Raymond |
|
|
|
|
NDF Full