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 |
SQL2000User
Starting Member
13 Posts |
Posted - 2006-08-21 : 14:44:53
|
I'm running a job for loading new data in database. Fristly, the job always kept 'Executing' status. then I found that the data available space is 0.00M even the auto growing is set up After I did some shrink and updated usage. there is some available space . but the job still can't get be done. The database size about 13575 MB but space available only 205.5mbThe disk free space is 37.5Gb, the data want to be inserted is about 200Mb. Can anyone have the idea about this issue? Thanks a lotFlora |
|
nosepicker
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-08-21 : 18:03:27
|
Since your databases are set to autogrow, this doesn't sound like a space issue. You'll have to look closer at your job/insert. Give us more details about this if you want further help. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-21 : 18:05:16
|
the space available stats can be inaccurate. You can run the DBCC UPDATEUSAGE command from query analyzer against your database and this will fix the space utilization stats.-ec |
|
|
nosepicker
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-08-22 : 00:03:27
|
Also, make sure your transaction log files are set to autogrow as well. |
|
|
|
|
|