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 |
|
Dance Doll
Yak Posting Veteran
54 Posts |
 Posted - 2008-03-24 : 09:28:50
|
| Our database was setup 10% auto grow. But few days ago, it stopped growing and whenever I tried to expand the data file size I got:Error 5149: MODIFY FILE encountered operating system error 1450(Insufficient system resources exist to complete the requested service.) while attempting to expand the physical file.Help, the DB is critical for us.Thanks in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-24 : 09:51:32
|
| Do you have space in your physical drives? |
 |
|
|
Dance Doll
Yak Posting Veteran
54 Posts |
Posted - 2008-03-24 : 09:53:55
|
| Yes, I have 30G free space. And the database data file is 15G. Log file is only 4MB. |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2008-03-24 : 10:11:39
|
| How much were you trying to expand the file?Mike"oh, that monkey is going to pay" |
|
|
|
Dance Doll
Yak Posting Veteran
54 Posts |
Posted - 2008-03-24 : 10:13:29
|
| I tried to expand 1G first, but failed.Then I tried few MBs, still failed. :( |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-24 : 21:55:16
|
| Check windows event log, you may have bad disk. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-03-25 : 16:30:56
|
| Is there a quota on the folder or Account the SQL service is running under? |
|
|
|
Dance Doll
Yak Posting Veteran
54 Posts |
Posted - 2008-03-26 : 09:38:48
|
| It's been running well before. Yes, the SQL Server service running using domain account. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-26 : 21:57:12
|
| You have to fix 1450 error first. |
|
|
|
|
|
|
expand the fhysical file