How to set using SQL Server Management Studio
- Right click on database name and select Properties
- Go to the Options page
- Under Recovery model select "Bulk-logged"
- Click "OK" to save
The advantage of using the "Bulk-logged" recovery model is that your transaction logs will not get that large if you are doing bulk operations and it still allows you to do point in time recovery as long as your last transaction log backup does not include a bulk operation
No comments:
Post a Comment