Answer / kanan

Mirrored backups

SQL Server 2005 lets you create mirrored backups. A mirrored
backup allows you to create two or four identical copies of
the backup files in case one of the sets is damaged.

Answer / senthilsjc

Hai hari...
Thnaks for ur answere..but

Don't post answer what u read in material

b'coz all are know backup type & recovery type
if u post answer its wanna most use full others
that's y i am asking..
this is my humble request..
don't mind..

carry onn..

Answer / hari

Back up is 3 types
Full backup
Differential backup
Transcational log backup

Recovery
simple recovery
full recovery
Bulk recovery

Why use identity in sql server?

0 Answers  

---

Is it ok to shrink transaction log?

0 Answers  

---

what is call by value & call by reference ?

2 Answers   Cap Gemini,

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  

---

Explain what is row_number function?

0 Answers  

---

---

What are mdf,ndf,ldf files and how to see the data in those files?

6 Answers   Accenture,

---

Explain system scalar functions?

0 Answers  

---

Explain various data region available in ssrs with their use?

0 Answers  

---

What are the differences between triggers and stored procedures?

0 Answers  

---

What is indexed view? How to create it?

0 Answers  

---

How can I create a table from another table without copying any values from the old table?

3 Answers  

---

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  

---