What is The Difference Between Full and Simple Recovery models in SQL SERVER

[@MSSQLDBATechSupport]

create database [full]
go
create database [simple]
USE [master]
GO
ALTER DATABASE [Full] SET RECOVERY FULL WITH NO_WAIT
GO
backup database [full] to disk = 'c:\Full.bak'
Go
backup database [SIMPLE] to disk = 'c:\simple.bak'
select name,recovery_model_desc from sys.databases where name in ('Full','simple')

[@Virustech1999]

Sir your interview session is too much good because ur going to deep dive n your concept of answer is very clear n satisfied thank you sir keep release this type of vidoe because it helps me n another again thnkx

[@MSSQLDBATechSupport]

Thanks and below is the playlist for answers
ruclips.net/p/PL-xn4QSr30Hb0nm4rWO3Ymgmre7ZHDHUq

[@damodhardaamu9925]

Hii sir can you please tell me how to do filter values above 30 for reorganize index after ran the index query

[@MSSQLDBATechSupport]

When u query for fragmentation results after that the basic thumb rule is if the fragmentation is greater than 30 we go for index rebuild and if less than we go for index reorganize. Please elaborate your query what u need to filter here.

[@damodhardaamu9925]

@@MSSQLDBATechSupport
How we filter the values for the reorganize index, please let me know the process

[@MSSQLDBATechSupport]

Do you want the T SQL query to see the fragmentation results.

[@saimadhav672]

Good explanation

[@MSSQLDBATechSupport]

Thanks and welcome

[@sreeramchandu]

Wonderfull

[@MSSQLDBATechSupport]

😊

[@krithidhanesh564]

Please put some video about how to recover the page corrupted db

[@MSSQLDBATechSupport]

sure