Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bulk Insert - Primary FileGroup is full
Message
From
31/05/2003 17:36:48
 
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
00793850
Message ID:
00794922
Views:
14
Yes. I've upgraded to the Standard version and that fixed the problem.

>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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform