In SQL server there are 3 different types of recovery models.
Each database mush be selected to any of these 3 recovery models.
Following are the types of recovery models used in SQL server.
Simple
Full
Bulk-Logged
T-SQL to change the recovery model of a database
ALTER DATABASE DATABASE_NAME
SET RECOVERY [Full / Simple / Bulk-Logged]
Each database mush be selected to any of these 3 recovery models.
Following are the types of recovery models used in SQL server.
Simple
Full
Bulk-Logged
T-SQL to change the recovery model of a database
ALTER DATABASE DATABASE_NAME
SET RECOVERY [Full / Simple / Bulk-Logged]
No comments:
Post a Comment