1. What is recorded in Transaction Log File.
2. Which types of backups are possible.
3. When the Transaction Log file is truncated.
4. Log shipping , Database mirroring are possible or not.
5. Point in time recovery is possible or not.
- SQL Server supports 3 types of recovery models
- Bulk Logged
ALTER DATABASE <dbName> SET RECOVERY <FULL/BULK_LOGGED/SIMPLE>
We can check the recovery model of database from sysdatabases or sys.databases view of master database.