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

Explain sql delete command?

0 Answers  

How do I make a resultset scrollable?

0 Answers  

Write a SQL Query to find first Week Day of month?

2 Answers  

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

How do you start single user mode in clustered installations?

0 Answers  

explain databases and sql server databases architecture? : Sql server database administration

0 Answers  

What are the default system databases in sql server 2000?

0 Answers  

Which sql server table is used to hold the stored procedure scripts?

0 Answers  

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

How to include text values in sql statements?

0 Answers  

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

0 Answers  

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

0 Answers   ABC,

For more SQL Server Interview Questions Click Here
Categories