Change the Database recovery model to simple while is in production
I have a database in production and I would like to run an ETL process to DELETE some records (200 millions) of the database but since the database is in FULL model every time I try to run the ETL the Logs file get out of space. In order to avoid that I would like to change the recovery model to simple, after I have done the process of cleaning the table I will put the recovery in full model again. Of course before start the process I will backup the Database. There is any Problem doing that, any recommendations?? Any assistance in this regard will be greatly appreciated.
Hi , I totally agree with WRBI, to delete the records in batches..say 50 K. I would like to add one more point here, you may also run checkpoint between those batches to make operation more efficient. Thanks