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 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
which background process invoke at the time of upgradation tell me???
Why would you use sql agent? : sql server DBA
what is grd?
What the different topologies in which replication can be configured? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Where do you find the default index fill factor and how to change it? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What is the difference between clustered and non-clustered index? : sql server DBA
what are the performance views in an oracle rac environment?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what are the benefits of flashback feature?