Explain the difference between a hot backup and a cold
backup and the benefits associated with each?
Answer Posted / sandeep
Cold Backup - In this case, they take the database down
then they have backup. this is called cold backup.
Hot Backup - In this case, they take running database
backup (like SQL Server) this is called hot backup.
| Is This Answer Correct ? | 29 Yes | 1 No |
Post New Answer View All Answers
internal architecture
What is the default port no on which sql server listens? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are statistics, under what circumstances they go out of date, how do you update them?
how can you connect from 10g user to 11g user??
How do you open a cluster administrator? : sql server DBA
what is asm?
how can you find out if a table can be redefined?
What are the commands you'd issue to show the explain plan for "select * from dual"?
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
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are the different types of indexes available in sql server? : sql server DBA
what do you understand by fine-grained auditing?