Communiquez avec les autres et partagez vos connaissances professionnelles

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

Suivre

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 ajoutée par Atiqul Islam , Sr Software Engineer , Prism Informatics Ltd
Date de publication: 2017/04/03
Muhammad Jawad
par Muhammad Jawad , Deputy Manager (MIS) , AL-NOOR GROUP MDF BOARD

After Backup You wont have these records which newly inserted.

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