Skip to main content
added 10 characters in body
Source Link

If you are working with Full Recovery Model, by definition you need Transaction Log Backups. If you don't need them it is useless to have Full Recovery Model.

You are not supossed to do shrinking in your way. Besides it reduces performance.

I suggest taking a transaction log backup and after that decide if you need Full or can go to Simple Recovery Model.

Also you can check active transactions maybe with dm_exec_sessions, and take a look of your fragmentation level on indexes to see if you have nonused space theresome configuration that preventsis not helping with your shrinking.

If you are working with Full Recovery Model, by definition you need Transaction Log Backups. If you don't need them it is useless to have Full Recovery Model.

You are not supossed to do shrinking in your way. Besides it reduces performance.

I suggest taking a transaction log backup and after that decide if you need Full or can go to Simple Recovery Model.

Also you can check active transactions maybe with dm_exec_sessions, and take a look of your fragmentation level on indexes to see if you have nonused space there that prevents your shrinking.

If you are working with Full Recovery Model, by definition you need Transaction Log Backups. If you don't need them it is useless to have Full Recovery Model.

You are not supossed to do shrinking in your way. Besides it reduces performance.

I suggest taking a transaction log backup and after that decide if you need Full or can go to Simple Recovery Model.

Also you can check active transactions maybe with dm_exec_sessions, and take a look of your fragmentation level on indexes to see if you have some configuration that is not helping with your shrinking.

added 195 characters in body
Source Link

If you are working with Full Recovery Model, by definition you need Transaction Log Backups. If you don't need them it is useless to have Full Recovery Model.

You are not supossed to do shrinking in your way. Besides it reduces performance.

I suggest taking a transaction log backup and after that decide if you need Full or can go to Simple Recovery Model.

Also you can check active transactions maybe with dm_exec_sessions, and take a look of your fragmentation level on indexes to see if you have nonused space there that prevents your shrinking.

If you are working with Full Recovery Model, by definition you need Transaction Log Backups. If you don't need them it is useless to have Full Recovery Model.

You are not supossed to do shrinking in your way. Besides it reduces performance.

I suggest taking a transaction log backup and after that decide if you need Full or can go to Simple Recovery Model.

If you are working with Full Recovery Model, by definition you need Transaction Log Backups. If you don't need them it is useless to have Full Recovery Model.

You are not supossed to do shrinking in your way. Besides it reduces performance.

I suggest taking a transaction log backup and after that decide if you need Full or can go to Simple Recovery Model.

Also you can check active transactions maybe with dm_exec_sessions, and take a look of your fragmentation level on indexes to see if you have nonused space there that prevents your shrinking.

Source Link

If you are working with Full Recovery Model, by definition you need Transaction Log Backups. If you don't need them it is useless to have Full Recovery Model.

You are not supossed to do shrinking in your way. Besides it reduces performance.

I suggest taking a transaction log backup and after that decide if you need Full or can go to Simple Recovery Model.