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
what is a user-defined lock?
What are statistics, under what circumstances they go out of date, how do you update them?
Explain materialized views and how they are used.
What are the different authentication modes in sql server and how can you change authentication mode? : 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?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What authentication modes does sql server support? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What the different topologies in which replication can be configured? : sql server DBA
how can you record information about current session?
what is the diffrence between core dba and apps dba?
what is logical system in sap basis
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?