In SQL Server, which recovery model can I use for the Point Of Sale?
In addition, I am working at the company that imports and sells automobile parts (car parts). So there should be a lot of transaction data.
The reason why I am asking this question is that I shrank the database because the storage of hard drive is full. And I changed the bulk-logged model to simple model and I changed it back again to the bulk-logged model. And the storage is almost full again.
Please let me know which recovery model will be suitable for the POS. And let me know if I can shrink the database in simple model and change it back to the bulk-logged after shrinking. And my company back up the database every 8hours and delete the old backup files after a month using maintenance plan.
Thank you!