Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Why do we use bulk_logged recovery model instead we have full recovery model to recover data in point in time recovery?

user-image
Question ajoutée par Utilisateur supprimé
Date de publication: 2016/10/06
haytham Hamdy
par haytham Hamdy , Developer , SAP

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) 

 

 

 

 

More Questions Like This