You need to import a large amount of data into a table in one of your production databases using a BULK INSERT statement. Put these steps in the correct order from optimum speed and reliability.
E – Run the BULK INSERT statement.
A – Set the database to use the Full recovery model.
D – Back up the database
( Before you insert the data, you should set the database to use the Bulk-logged recovery model because it is fastest for inserting bulk data. Next, since this is a production database, it is safe to assume that it was using the Full recovery model, so don’t forget to set it back to Full. Finally, after running the statement, you need to back up the database because you will lose your bulk-imported data if the database crashes before your next scheduled backup.)