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.

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

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.

Do you know query execution plan?

0 Answers  

---

Define msdb database?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers   HCL,

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

0 Answers  

---

How do I create an extended event in sql server?

0 Answers  

---

---

What are temporal tables in sql server 2016?

0 Answers  

---

What is table value parameters (tvp)?

0 Answers  

---

how many layers of tcp/ip protocol combined of? : Sql server database administration

0 Answers  

---

What are the different types of indexes?

0 Answers   Blue Star,

---

What is difference between rownum and rowid?

0 Answers  

---

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

---

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  

---