Secondary File in use and growing

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Secondary File in use and growing

Author

Topic

ekveda
Starting Member

4 Posts

Posted - 2007-07-02 : 03:39:11

Hi,

After doing the purge and re-indexing on database, the main file is not active. I mean the ndf file has started growing.

The mdf file is about 84 GB
ldf was 3 GB which has now become 16GB
and also the ldf is not active. it is about 13 GB

Urgent help will be appriciated as I will run out of space.........
Thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-02 : 11:47:26

If ndf file is in same file group with mdf file, sql will put more data in it untill its size matches mdf file.

b.veenings
Yak Posting Veteran

96 Posts

Posted - 2007-07-04 : 07:15:11

Hi,

where do you want to go to?

Do you want the .mdf to enable as default datafile?
eventually you get the same problem if you let it grow further on the mdf file, what kind of data does the ndf file contains?

cheers,
Benjamin

Need an SQL consultant?
check www.veeningsengineering.nl

b.veenings
Yak Posting Veteran

96 Posts

Posted - 2007-07-04 : 07:18:24

quote:
Originally posted by b.veenings

Hi,

where do you want to go to?

Do you want the .mdf to enable as default datafile?
eventually you get the same problem if you let it grow further on the mdf file, what kind of data does the ndf file contains?

cheers,
Benjamin

Need an SQL consultant?
check www.veeningsengineering.nl

if you want to change t use :
USE master
GO
ALTER DATABASE MyDatabase
MODIFY FILEGROUP [PRIMARY] DEFAULT
GO

Need an SQL consultant?
check www.veeningsengineering.nl

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources