Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
Data Recovery Model are designed to control :
1- Transaction Log
2- Types Of Backup On Database
3 - Behaviour Of Bulk Insert Statement
There Are Three Types Of Recovery Model
1- Simple 2 - Full 3- Bulk_Logged
Simple :
If I have insert Statement write it in the log file and send it to the data file(database ) and back to remove it from log file.
Backup : (No Log Backups) Can make (Full , Differentail ,Filegroup Backups) .
Full & Bulk-Logged :
as same as the Simple work But Not Remove It From Log File.
BUT
If I have 4 bulk Insert Statement
IN BULK_LOGGED : Write It in Log File as ONE Bulk Statement
IN FULL : Write It in Log File as FOUR Bulk Statement
Backup:
Support All Types of Backups :
1-Full Backup (Full Backup Data File )
2-Differentail Backup (After Full Backup Get Last Full Backup)
3- Transaction Log Backup (Restore Log Files Tranaction)
4- File Group Backup (If Database Big Can Groups Set OF Files and Restore it)