Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bulk Insert - Primary FileGroup is full
Message
 
À
29/05/2003 06:38:32
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
00793850
Message ID:
00793865
Vues:
18
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform