Can anybody explain me cold backup and hot backup?

Answer Posted / rajendra

Cold Backup and Hot Backup terms are used by Oracle. These
terms are not available In MS SQL Server.

Cold Backup: - Takes the Database offline and copy database
files to different loction is called cold backup in Oracle.

Hot Backup:- Taking the Database backup when the Database
is online.

Is This Answer Correct ?    20 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

89


What is transaction server explicit transaction?

554


Define tool Manage Statistics in SQL Server 2000 query ?

533


Can you please differentiate between a primary key and a unique key?

546


How can sql server instances be hidden?

533






What the different topologies in which replication can be configured?

566


What is full outer join in sql server joins?

579


What are types of scd? : sql server analysis services, ssas

546


What is the command to change the recovery model?

577


What do you mean by an execution plan? Why is it used?

545


What is a partitioned view?

584


How do I find information about the install locations for the various instances running on a computer?

564


what type of index will get created after executing the above statement? : Sql server database administration

550


What are trace flags and mention a few common trace flags used with sql server?

561


How can sql injection be stopped? : sql server security

562