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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-05 : 08:15:49
|
| June dela cruz writes "Hi, when i run my dts. I got this error Could not allocate space for object 'calltrak1' in database 'Strataware' because the 'PRIMARY' filegroup is full. What is causing this, how can i get rid of it.Thanks" |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-12-05 : 09:59:46
|
| Possible reasons: Maybe you don't have space on disk anymore.Please check if you have free disk space.Also check if Automatic Grow file is set.If it is set NOT to autogrow then you can try to increase the size manually.Check BOL for more info on filegroups.HTHFranco |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-12-06 : 03:09:37
|
| The usual reason for this is that the database is set to the full recovery model but no transaction log backups are being performed. If this is the case then set the recovery model to simple on all databases and shrink the databases.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Primary file group is Full