Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Can anybody explain me cold backup and hot backup?

Question Posted / ppd_testing

Answers were Sorted based on User's Feedback



Can anybody explain me cold backup and hot backup? ..

Answer / 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

Can anybody explain me cold backup and hot backup? ..

Answer / guenter

i think both of the above answers are right:
Cold Server backups:
http://www.microsoft.com/licensing/software-assurance/cold-
backup.aspx
Oracle Database Cold Backup:
http://www.oracle.com/technology/pub/articles/havewala-rman-
grid.html

Is This Answer Correct ?    3 Yes 1 No

Can anybody explain me cold backup and hot backup? ..

Answer / samriti

Cold Server backups goes for those machine which have
software installed and configured and then turned off.

Hot Server backups are those which frequently are turned
on and ready to move into production mode immediately.

Is This Answer Correct ?    2 Yes 17 No

Post New Answer

More SQL Server Interview Questions

What are the features of Embedded SQL

0 Answers   HCL,

What is the difference between SQL notification and SQL invalidation?

0 Answers   MindCracker,

What is a self join in sql server?

0 Answers  

Define msdb database?

0 Answers  

Write a SQL query in order to merge two different columns into single column?

0 Answers   QuestPond,

How to enter unicode character string literals in ms sql server?

0 Answers  

What’s the distinction between dropping a info and taking a info offline?

0 Answers  

How to execute a sql statement using mssql_query()?

0 Answers  

what is the difference between group and having give an example with query and sample output

7 Answers  

What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

What is mean by candidate key?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories