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?
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 |
Where do you find the default index fill factor and how to change it? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How would you extract DDL of a table without using a GUI tool?
what is the purpose of catlaog in oracle rman?
Explain the difference between a data block, an extent and a segment.
Give the reasoning behind using an index.
What is the difference between online backup & offline backup?
What are the commands you'd issue to show the explain plan for "select * from dual"?
what is a crs resource?
how can you find out if a table can be redefined?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)