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 is database replication? What are the different types of replication you can set up in sql server?

0 Answers  

What is difference between equi join and natural join?

0 Answers  

what are triggers? : Sql server database administration

0 Answers  

What do mean by xml datatype?

0 Answers  

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

0 Answers  

What are the requirements to use odbc connections in php scripts?

0 Answers  

If a stored procedure is taking a table data type, how it looks?

1 Answers  

How to run sql server 2005 books online on your local system?

0 Answers  

Explain indexes disadvantages?

0 Answers  

List the different normalization forms?

0 Answers  

What is de-normalization and what are some of the examples of it?

0 Answers  

Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

For more SQL Server Interview Questions Click Here
Categories