1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

if monday take full backup and tuesday it was cumulative
backup and wednesday we taken incremental backup, thursday
some disaster happen then what type of recovery and how it
will take?

Question Posted / anuradha


if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental ..

Answer / braj123

--> Restore the monday full backup+tuesday cumulative
backup+wednesday Incremental backup.(bcz cumulative and
incremental clears the archives every backup).

--> Recover the database
--> reset the logs

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

You have just compiled a PL/SQL package but got errors, how would you view the errors?

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  

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  




what is logical system in sap basis

0 Answers  

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

What happens on checkpoint? : sql server DBA

0 Answers  

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

When a user process fails, what background process cleans up after it?

1 Answers  

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

For more DB Administration Interview Questions Click Here
Categories