ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل مستخدم محذوف‎
تاريخ النشر: 2016/10/06
haytham Hamdy
من قبل 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) 

 

 

 

 

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟