primary filegroup is full

[Jasmin]

I have around 9 index to a table and when I transfer my table with the help of Import/Export utility I get this error, can any1 tell me, why do I'm getting this error and I don't have help on that.

Error:
--------
Error at Destination for Row number 2279. Errors encountered so far in this task: 1

could not allocate space for object 'a_pua01_tblmdlmast' in database dbDev because the primary filegroup is full
---------

Thankx for ur help

[Attaullah]

Seems like the space allocated to the file is not enough.
Please increase the space and try again.

Good Luck.

Attaullah

------------
Jasmin at 7/12/00 2:12:05 PM


I have around 9 index to a table and when I transfer my table with the help of Import/Export utility I get this error, can any1 tell me, why do I'm getting this error and I don't have help on that.

Error:
--------
Error at Destination for Row number 2279. Errors encountered so far in this task: 1

could not allocate space for object 'a_pua01_tblmdlmast' in database dbDev because the primary filegroup is full
---------

Thankx for ur help

Thanks for reply

How can I increase the space and from where, can you guide me pls.

Jas

------------
Attaullah at 7/12/00 2:18:53 PM



Seems like the space allocated to the file is not enough.
Please increase the space and try again.

Good Luck.

Attaullah

------------
Jasmin at 7/12/00 2:12:05 PM


I have around 9 index to a table and when I transfer my table with the help of Import/Export utility I get this error, can any1 tell me, why do I'm getting this error and I don't have help on that.

Error:
--------
Error at Destination for Row number 2279. Errors encountered so far in this task: 1

could not allocate space for object 'a_pua01_tblmdlmast' in database dbDev because the primary filegroup is full
---------

Thankx for ur help

[Ram]

Hi,

What version of sql server you are using. If it is 7.0 you better check the auto file growth in the properties of the database. If you want to add another filegroup to the database you can use
ALTER DATABASE database
ADD FILEGROUP filegroup_name

Goodluck


------------
at 7/12/00 2:54:47 PM


Thanks for reply

How can I increase the space and from where, can you guide me pls.

Jas

------------
Attaullah at 7/12/00 2:18:53 PM



Seems like the space allocated to the file is not enough.
Please increase the space and try again.

Good Luck.

Attaullah

------------
Jasmin at 7/12/00 2:12:05 PM


I have around 9 index to a table and when I transfer my table with the help of Import/Export utility I get this error, can any1 tell me, why do I'm getting this error and I don't have help on that.

Error:
--------
Error at Destination for Row number 2279. Errors encountered so far in this task: 1

could not allocate space for object 'a_pua01_tblmdlmast' in database dbDev because the primary filegroup is full
---------

Thankx for ur help

[Attaullah]

Are you using Enterprise Manager?
If yes then right click on the database and choose prperties.
Select the Unrestricted filegrowth Button.

Also select Bypercent Button and make it 10.
Click on Apply and then OK.

If any quwstions please contact me directly.

Attaullah
a_wazir@hotmail.com

------------
at 7/12/00 2:54:47 PM


Thanks for reply

How can I increase the space and from where, can you guide me pls.

Jas

------------
Attaullah at 7/12/00 2:18:53 PM



Seems like the space allocated to the file is not enough.
Please increase the space and try again.

Good Luck.

Attaullah

------------
Jasmin at 7/12/00 2:12:05 PM


I have around 9 index to a table and when I transfer my table with the help of Import/Export utility I get this error, can any1 tell me, why do I'm getting this error and I don't have help on that.

Error:
--------
Error at Destination for Row number 2279. Errors encountered so far in this task: 1

could not allocate space for object 'a_pua01_tblmdlmast' in database dbDev because the primary filegroup is full
---------

Thankx for ur help