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 the importance of a recovery model?

0 Answers  

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

What is the default sql server instance name?

0 Answers  

What does the on delete cascade option do?

0 Answers  

What is a natural primary key?

0 Answers  

how to implement locking in sql server

3 Answers   Satyam,

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 Answers  

What types of integrity are enforced by a foreign-key constraint

1 Answers  

What happens if null values are involved in arithmetic operations?

0 Answers  

Where to find ntwdblib.dll version 2000.80.194.0?

0 Answers  

can you any body tell me the how to decrease the logfile

4 Answers  

Explain optimistic and pessimistic concurrency?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories