disable logging

Is there is a way to disable logging as i need to
transfer 4000000 records from oracle..I am doing throgh
this DTS..my transaction los size grows more than 10 GB..Hi,
To prevent the transaction log from running out of space, a minimally logged
bulk copy can be performed if all of these conditions are met:-
a.. The recovery model is simple or bulk-logged.
b.. The target table is not being replicated.
c.. The target table does not have any triggers.
d.. The target table with no indexes (Remove and create after loading).
The model bulk_logged / simple recovery will prevent the bulk copy
operations from using excessive log space and possibly filling the log.
However, even with bulk-logged recovery, some transaction log space will be
used. You may want to create transaction log backups during the bulk copy
operation to free up transaction log space.
Note:
After the operation change the recovery to FULL and then perform afull
system backup and then follow ur transaction log backup (If you have).
This bring back ur backup chain.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:ba7e01c43801$d0b6f330$a401280a@.phx.gbl...
> Is there is a way to disable logging as i need to
> transfer 4000000 records from oracle..I am doing throgh
> this DTS..my transaction los size grows more than 10 GB..
>|||Hi,
To prevent the transaction log from running out of space, a minimally logged
bulk copy can be performed if all of these conditions are met:-
a.. The recovery model is simple or bulk-logged.
b.. The target table is not being replicated.
c.. The target table does not have any triggers.
d.. The target table with no indexes (Remove and create after loading).
The model bulk_logged / simple recovery will prevent the bulk copy
operations from using excessive log space and possibly filling the log.
However, even with bulk-logged recovery, some transaction log space will be
used. You may want to create transaction log backups during the bulk copy
operation to free up transaction log space.
Note:
After the operation change the recovery to FULL and then perform afull
system backup and then follow ur transaction log backup (If you have).
This bring back ur backup chain.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:ba7e01c43801$d0b6f330$a401280a@.phx.gbl...
> Is there is a way to disable logging as i need to
> transfer 4000000 records from oracle..I am doing throgh
> this DTS..my transaction los size grows more than 10 GB..
>