I am trying to import records via bcp (about 1,500,000 records) and I keep running out of disk space. Is there any way to limit or do away with the transaction log (and still be able to import)?
Printable View
I am trying to import records via bcp (about 1,500,000 records) and I keep running out of disk space. Is there any way to limit or do away with the transaction log (and still be able to import)?
On 8/20/98 3:32:03 PM, Melissa wrote:
> I am trying to import records via bcp (about 1,500,000 records) and I keep
> running out of disk space. Is there any way to limit or do away with the
> transaction log (and still be able to import)?
I think setting the db in bulkcopy mode will help
Actually changing the settings arent enough.
BCP in the records in smaller chunks using the -F (firstrecord) and -L (lastrecord) switches to bcp.
On 8/23/98 10:10:19 AM, Uwe Janke wrote:
> On 8/20/98 3:32:03 PM, Melissa wrote:
> I am trying to import records via
> bcp (about 1,500,000 records) and I keep
> running out of disk space. Is
> there any way to limit or do away with the
> transaction log (and still
> be able to import)?
I think setting the db in bulkcopy mode will help