hi, how can i check all backups are exist to restore? I.e. i forget to take ba

hi, how can i check all backups are exist to restore? I.e.
i forget to take backup on one day. But now i want to check
that all backups are there to restore now. I know the
answer of through timestamps we know how to check. But i
need any other way?

Question Posted / shravan

1 Answers
4253 Views
I also Faced
E-Mail Answers

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But..

Answer / kamal

if full backup has been taken , you can restore at any
time . if differential has been taken checkup the last full
backup date then verify diff. backup has been taken
immediate after that or not if not find the date & time for
which it was left and take diff. backup of that .

Is This Answer Correct ?

4 Yes

0 No

Post New Answer

More DB Administration Interview Questions

how will u see whether the dabase is in archive log mode or not?

2 Answers CSC,

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers

How does Oracle guarantee data integrity of data changes?

1 Answers SoftSol,

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers

Can we take incremental backups in datapump?

1 Answers

why we use cursors

1 Answers

Explain what partitioning is and what its benefit is.

2 Answers

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?