• Hi Brad,

    SQL Server is a little different than Oracle and wasn't sure which 'Bulk Insert' you were referring too...

    You can set the database into a 'BULK' recovery model with:

    ALTER DATABASE <dbName> SET RECOVERY BULK LOGGED.

    As long as your other jobs are not Bulk inserts you will still be able to recover them.

    From Books Online:

    When BULK_LOGGED is specified, logging for all SELECT INTO, CREATE INDEX, and bulk loading data operations is minimal and therefore requires less log space. In exchange for better performance and less log space usage, the risk of exposure to loss is greater than with full recovery. For more information, see Bulk-Logged Recovery.

    You may want to look into the BCP (kind of like a week SQL*Loader) command and DTS packages.


    "Keep Your Stick On the Ice" ..Red Green