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
4182 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

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers

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

0 Answers

how can you find out if a table can be redefined?

0 Answers Oracle,

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers

What is the importance of a recovery model? : sql server DBA

0 Answers

What is the difference between Datapump & export/import?

2 Answers

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA