Bulk Insert Runs out of space

Hello,
I am running a Bulk Insert and getting the error that the PRIMARY file group
is full. All the databases in the server have the Autogrow check box
selected and there is over a 100 GB space available on the hard drive. The
transaction log is set to autogrow as well.
Is there a maximum file size for the primary datafile? The size is
currently at 1.8 GB
Can someone help with some ideas for getting around this error.
Thanks
Hardee Mahoney
Washington, DC USA
Thank you for your reply. That explains it.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:51bm4eF1jbqr6U1@.mid.individual.net...
> hi,
> Hardee Mahoney wrote:
> MSDE has a limit of 2gb for each database (data file(s) only)...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
|||Remember that first, bulk copy does not write to the transaction log. Next,
SQL Express has twice (4GB) data capacity. However, if you're running out of
space with MSDE, I would reconsider what you're storing in the database. Are
you using it to store BLOBs? If so, consider storing those on a file share
and putting the path in the database.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
Between now and Nov. 6th 2006 you can sign up for a substantial discount.
Look for the "Early Bird" discount checkbox on the registration form...
------
Microsoft MVP, Author, Mentor
Microsoft MVP
"Hardee Mahoney" <hardee_mahoney@.abtassoc.com> wrote in message
news:OLMB568OHHA.2140@.TK2MSFTNGP03.phx.gbl...
> Thank you for your reply. That explains it.
>
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:51bm4eF1jbqr6U1@.mid.individual.net...
>

Bulk insert every other row?

Is it possible to do a bulk insert of every other row? I have a file that
is double space - meaning a data row then a blank row, etc. . I thought I
could just use a row delimiter of CRLF twice, but that didn't work. Any
help would be appreciated!
Nieves:
Probably easier just to run a single DELETE op after the import?
$0.00000001's worth ;)
Robert
"Nieves" <JuanN@.yahoo.com> wrote in message
news:uuQ6GEHRGHA.5552@.TK2MSFTNGP14.phx.gbl...
> Is it possible to do a bulk insert of every other row? I have a file that
> is double space - meaning a data row then a blank row, etc. . I thought
> I could just use a row delimiter of CRLF twice, but that didn't work. Any
> help would be appreciated!
>
|||Thought of that, but I just wanted to find out if my original question was
possible.
Thanks!
"Robert Ellis" <robe_2k5.n0sp8m@.hotmail.co.uk> wrote in message
news:OhFVqHHRGHA.5900@.tk2msftngp13.phx.gbl...
> Nieves:
> Probably easier just to run a single DELETE op after the import?
> $0.00000001's worth ;)
> Robert
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:uuQ6GEHRGHA.5552@.TK2MSFTNGP14.phx.gbl...
>

Bulk insert every other row?

Is it possible to do a bulk insert of every other row? I have a file that
is double space - meaning a data row then a blank row, etc. . I thought I
could just use a row delimiter of CRLF twice, but that didn't work. Any
help would be appreciated!Nieves:
Probably easier just to run a single DELETE op after the import?
$0.00000001's worth ;)
Robert
"Nieves" <JuanN@.yahoo.com> wrote in message
news:uuQ6GEHRGHA.5552@.TK2MSFTNGP14.phx.gbl...
> Is it possible to do a bulk insert of every other row? I have a file that
> is double space - meaning a data row then a blank row, etc. . I thought
> I could just use a row delimiter of CRLF twice, but that didn't work. Any
> help would be appreciated!
>|||Thought of that, but I just wanted to find out if my original question was
possible.
Thanks!
"Robert Ellis" <robe_2k5.n0sp8m@.hotmail.co.uk> wrote in message
news:OhFVqHHRGHA.5900@.tk2msftngp13.phx.gbl...
> Nieves:
> Probably easier just to run a single DELETE op after the import?
> $0.00000001's worth ;)
> Robert
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:uuQ6GEHRGHA.5552@.TK2MSFTNGP14.phx.gbl...
>> Is it possible to do a bulk insert of every other row? I have a file
>> that is double space - meaning a data row then a blank row, etc. . I
>> thought I could just use a row delimiter of CRLF twice, but that didn't
>> work. Any help would be appreciated!
>

Bulk insert every other row?

Is it possible to do a bulk insert of every other row? I have a file that
is double space - meaning a data row then a blank row, etc. . I thought I
could just use a row delimiter of CRLF twice, but that didn't work. Any
help would be appreciated!Nieves:
Probably easier just to run a single DELETE op after the import?
$0.00000001's worth ;)
Robert
"Nieves" <JuanN@.yahoo.com> wrote in message
news:uuQ6GEHRGHA.5552@.TK2MSFTNGP14.phx.gbl...
> Is it possible to do a bulk insert of every other row? I have a file that
> is double space - meaning a data row then a blank row, etc. . I thought
> I could just use a row delimiter of CRLF twice, but that didn't work. Any
> help would be appreciated!
>|||Thought of that, but I just wanted to find out if my original question was
possible.
Thanks!
"Robert Ellis" <robe_2k5.n0sp8m@.hotmail.co.uk> wrote in message
news:OhFVqHHRGHA.5900@.tk2msftngp13.phx.gbl...
> Nieves:
> Probably easier just to run a single DELETE op after the import?
> $0.00000001's worth ;)
> Robert
> "Nieves" <JuanN@.yahoo.com> wrote in message
> news:uuQ6GEHRGHA.5552@.TK2MSFTNGP14.phx.gbl...
>