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

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

متابعة

Started a db backup at 10.10 AM & required 20 min for completion. @10.25 AM we inserted few rows in a table. Will new data be there in backup db?

user-image
تم إضافة السؤال من قبل Atiqul Islam , Sr Software Engineer , Prism Informatics Ltd
تاريخ النشر: 2017/04/03
Muhammad Jawad
من قبل Muhammad Jawad , Deputy Manager (MIS) , AL-NOOR GROUP MDF BOARD

After Backup You wont have these records which newly inserted.

Syed M Shahbaz Alam
من قبل Syed M Shahbaz Alam , Senior Manager IT , Mutual Funds Association of Pakistan

You won't find newly inserted row in backup copy, but the newly inserted will be in primary db

ELIE LAHOUD
من قبل ELIE LAHOUD , Senior Integration Engineer & Publishing Consultant , Layout International

It's impossible because when you start Backing up the database it will take the last one before the backup process began

Praveen Kumar Malarouthu
من قبل Praveen Kumar Malarouthu , Robotic Process Automation Developer , Innovsol Systems and Technologies

It should be possible in the Case of RDBMS like Oracle.

DB in Two Layers i.e. Logical and Physical would help serve the purpose.

Thanks

Wael Inaim
من قبل Wael Inaim , Manager of Information Technology Section. , Khatib & Alami

once you issue the backup command it will backup the data at the time of command given, so the new data won't be in the backup but it will be inserted in the table.

Mohammad Yousef
من قبل Mohammad Yousef , ERP Application Manager , Mohammed Bin Al-Shaikh Sons’ Group

No, the records inserted 10.25 will be in the database log and the database as well if it is committed, but it will not be in the database backup. 

Abdullah ilyas
من قبل Abdullah ilyas , Network & System Engineer , Nextbridge

The newly inserted data will not be available because when backup is started, all tables are locked. hence new record will not be available in the backup.

Badr Djemoui
من قبل Badr Djemoui

that my experience the buck up need effected betwin transactions that means your data inserted is in the data base but is not in the backup.

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