Posted on 2011-03-23
I have some confusion to start using bulk_logged recovery model. currently our db run with FULL recovery, but everyday around 9am - 11am ( 2 hours ), our bulk insert and select into is running. so I'm thinking to change the recovery during this 2 hour time to Bulk_logged.
So when I change the recovery mode to Bulk_Logged at 9am-11am, and if there is some insert or delete or update occurring during this hour, will I lost this data if point in time recovery is needed ?