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 #temp and @table variable in SQL server?

0 Answers  

How many types of schemas are there?

0 Answers  

How to change location of errorlog in SQL?

2 Answers   ABC, IBM,

List the different types of joins?

0 Answers  

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

Explain sql server authentication modes?

0 Answers  

What is partition, how will you implement it? : sql server analysis services, ssas

0 Answers  

What is normalization and what are the advantages of it?

0 Answers  

Which Model uses the SET concept

0 Answers   Infosys,

What is a user-defined function in the sql server and what is its advantage?

0 Answers  

How to include date and time values in sql statements?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories