bulk insert

• sandhyarao49

  SSCrazy

  Points: 2215

  More actions

  April 28, 2008 at 8:29 am

  #187065

  I have a small doubt. I have a database in bulk-logged recovery model.

  At 10 AM full backup.

  At 11 Am transaction log backup.

  At 11.30 Am one lakh records are inserted (bulk operations) i.e bulk insert

  At 12 pm transaction log backup.

  Suppose if my server crashes at 12 .30 PM can we able to recover that one lakh records.

  My order of restore is 10 Am full backup, 11Am transaction log backup.

  and 12 Pm transaction log backup.

  With this can we able recover that one lakh records

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  April 29, 2008 at 10:01 am

  #808520

  You can.

  What you cannot is that you cannot recover to a time point during your bulk insert.