RE: What is Recovery Model in SQL Server

You are viewing a single comment's thread from:

What is Recovery Model in SQL Server

in sqlrecovery •  3 years ago 

Recovery models are used to determine what data to maintain in the transaction log file, as well as when to keep it.
Recovery models in SQL Server are as follows:
Full
Simple
Bulk-Logged
Each database can only have one recovery model, but each of your databases can have a different recovery model, so you can choose the best solution for each database based on the processing and backup requirements. The only exception is the TempDB database, as it must employ the Simple recovery model.
Also, the database recovery model can be modified at any moment, but this will have an influence on your backup chain, so it's a good idea to perform a full backup after making this change.
The recovery model can be altered using T-SQL or SQL Tools that might save user’s time and efforts.

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!