Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 4074 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
how can you create a user-defined lock?
What is dbcc? : 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 can you process messages in order asynchronously?
What are the commands used in dcl? : sql server DBA
what is asm?
how can a session indicate its interest in receiving alerts?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is the difference between clustered and non-clustered index? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is the default port no on which sql server listens? : sql server DBA
what is logical system in sap basis
Why would you use sql agent? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
How would you go about verifying the network name that the local_listener is currently using?
