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

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers

How can you enable a trace for a session?

1 Answers

Explain the use of table functions.

1 Answers

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers Tech Mahindra,

what is the use of home directory???

1 Answers HP,

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA