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 |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2012-02-24 : 13:22:27
|
| Hi Experts,one of my Drive is full with .ndf file. the drive is about 134Gb and .ndf file is using the full space now there is only 10mb left. what is the best way to come out of this situation.can we shring the db files by taking a backup or is there any other way to come out of this.please suggest me Thank you in Advance. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-02-24 : 13:36:21
|
| Thank you for quick response but there is no time to increase the space rightaway as there is a procedure for that. is there any temporary solution so that the db can not go into suspect mode. and meanwhile we can raise a request for space with our wintel team. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kinnerton
Starting Member
21 Posts |
Posted - 2012-03-02 : 06:14:56
|
| Shrinking would not really help. You'd break all of your indexes and only reduce the database physical footprint - you don't get more space.The main two options are listed above. Either more disk space, or delete data.If you have other drives with space and you have Enterprise you could partition - but I don't know if it's too late for that.Kinnerton |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-02 : 10:08:47
|
| The database won't go suspect. The only thing that will happen is if the entire filegroup that ndf is part of is full, and then you'll get an error when you try to insert rows saying that SQL can't allocate more space in the file. Solution: add more disk space, or delete data from that database.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Drive is full