What do you mean by Recovery Model and types of it in SQL Server?

HomePage Jobs WalkIn Articles Group Chat Contact Us Feedback Sitemap

	To improves our performance please Like Share Subscribe(Will boost us)
	Follow

What do you mean by Recovery Model and types of it in SQL Server?
Question Posted on 28 Sep 2022Home >> DataBase >> sql questions >> What do you mean by Recovery Model and types of it in SQL Server?

What do you mean by Recovery Model and types of it in SQL Server?
When we say about recovery model it will tells SQL Server what data should we kept in the tranaction log file and for how long. And a database can have only one recovery model. And this will also tells SQl Server which backup is possible in a particular selected recovery model.

Below are the three types of recovery models in SQL Server:-
(1)Full
(2)Simple
(3)Bulk-Logged

	0
	0


	.

	Most Visited Questions:-
	Deep Learning Questions Answers Below are the different Deep Leaning Questions and answer a More...
	Continuous Integration Questions Answers Below are the 20 odd questions for CI or Continuous Integra More...
	Derived relationships in Association Rule Mining are represented in the form of __________. Derived relationships in Association Rule Mining are repres More...
	What is Gulpjs and some multiple choice questions on Gulp Gulpjs is an open source whihc helps in building Javascript More...
	Microservices Architecture Questions Answers Below are the different questions on Microservices Architec More...

To improves our performance please Like Share Subscribe(Will boost us)