Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between a hot backup and a cold
backup and the benefits associated with each?
- 7 Answers
- 21852 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / shabbeer.ahmad
A hot backup is basically taking a backup of the database
while it is still up and running and it must be in archive
log mode. A cold backup is taking a backup of the database
while it is shut down and does not require being in archive
log mode. The benefit of taking a hot backup is that the
database is still available for use while the backup is
occurring and you can recover the database to any point in
time. The benefit of taking a cold backup is that it is
typically easier to administer the backup and recovery
process. In addition, since you are taking cold backups the
database does not require being in archive log mode and thus
there will be a slight performance gain as the database is
not cutting archive logs to disk.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What is a system database and what is a user database? : sql server DBA
who owns the operating system files created by the utl_file package?
How can you control the amount of free space in your index pages? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
What the different topologies in which replication can be configured? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the commands used in dcl? : sql server DBA
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
how to restore files with rman?
What types of replication are supported in sql server? : sql server DBA
Why would you use sql agent? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
how can you record information about current session?
