
Explanation/Reference:
Explanation:
Step 1: Perform a full backup of the database and enable the bulk-logged recovery model.
Not: Simple recovery model.
With the Simple recovery model we cannot minimize data loss.
Step 2: Import the data
Step 3: Backup the tail of the transaction log.
For databases that use full and bulk-logged recovery, database backups are necessary but not sufficient.
Transaction log backups are also required.
Note: Three recovery models exist: simple, full, and bulk-logged. Typically, a database uses the full recovery model or simple recovery model. A database can be switched to another recovery model at any time.
References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models- sql-server