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 |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2006-06-22 : 08:01:24
|
| Hi all,When i am trying to insert some rows in a databases, i got the following error..Could not allocate space for object 'SYSTEM_TRACKING' in database 'A2PD' because the 'INDEXES' filegroup is full. How can i resolve this issue..Thanks in advance.. |
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-06-22 : 08:22:21
|
| Is the database size limited?or Is the disk full? |
 |
|
|
venkath
Posting Yak Master
202 Posts |
Posted - 2006-06-22 : 08:34:59
|
| The database size is limited..If possible pls tell me how to fix in both scenarios..Thanks |
|
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-06-22 : 08:43:40
|
| On SQL Server 2000If the database is limited:1 Go to Enterprise Manager.2 Click on the Server that the database lives on3 Click on Databases4 Find you database and right click on it5 Click on Properties6 Select the Datafiles tab7 Make sure the "Automatically grow file" checkbox is ticked.8 Select the Maximum file size to "Unrestricted File Growth"9 Then click on the Transaction Log tab and repeat steps 7 and 8.If the disk is full. Free up some space on the physical disk that database/transaction log lives on. You can determine the letter of that disk from the same tabs as above (by looking at the path under "location".Hope that helps. |
|
|
|
|
|
|
'INDEXES' filegroup is full