Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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
Question added by Atiqul Islam , Sr Software Engineer , Prism Informatics Ltd
Date Posted: 2017/04/03
Muhammad Jawad
by Muhammad Jawad , Deputy Manager (MIS) , AL-NOOR GROUP MDF BOARD

After Backup You wont have these records which newly inserted.

Syed M Shahbaz Alam
by 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
by 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
by 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
by 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
by 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
by 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.

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.

More Questions Like This