Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bulk Insert - Primary FileGroup is full
Message
 
To
29/05/2003 06:38:32
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
00793850
Message ID:
00793865
Views:
19
This message has been marked as the solution to the initial question of the thread.
Are you using SQL Server or MSDE? MSDE Does have the 2GB database limit so that may be the problem. I use Bulk Insert called from within a VB6 app to insert files with up to 100,000 records daily (no where neae 3 gigs) - and it works OK.

>I'm getting the following error when issuing a Bulk Import with a format file.
>
>"could not allocate space for object '< table name >' in database location because primary
>filegroup is full"
>
>I'm attempting to import about 3 gigs of data ( basically just a flat file ).
>
>I attempted to attach a database of approximately the same size and I recieved the following error.
>
>"Error 1827: CREATE/ALTER DATABASE failed because resulting cumulative database size would exceed your licensed limit of 2048 MB per database."
>
>Is this just a licensing issue?
Al Williams

Anola MB, CANADA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform