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

What is sharding?

88


How to generate create function script on an existing function?

596


What are entities and relationships?

564


How you would rewrite the sql query to return the customerid sorted numerically?

575


How to Sync Two SQL Azure Databases?

101






Is ssrs support other database except ms sql server?

96


Differentiate between a local and a global temporary table?

545


What are the different types of collation sensitivity?

561


You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

552


How to disable a login name in ms sql server?

598


What is order of B+tree?

665


What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

579


In case you have filters in your report, when filters will be applied in cached report instance?

81


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

1449


Do you know what is rank function?

628