Answer / dharmesh tandel

Differential Back: Only those files will be included which
have been changed since the last FULL backup.

http://www.orionsoftlab.com/backup/backup_anywhere.gif

Answer / pradeepreddy

differential backup backups only changes made in the
database on to backup media since the last full backup

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

---

Without Using Cursors , How to Select the Selected row??

3 Answers   CarrizalSoft Technologies, Wipro,

---

Security Question- SQL DBA exparts, need your help...

3 Answers  

---

What are the tool windows in sql server management studio? : sql server management studio

0 Answers  

---

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers  

---

What are the different types of locks in the database?

0 Answers  

---

What is indexed view? How to create it?

0 Answers  

---

What are the advantages of user defined function?

0 Answers  

---

What is the difference between constraints and triggers?

9 Answers   Wipro,

---

What does the not null constraint do?

0 Answers  

---

Explain indexed view?

1 Answers  

---

What is the difference between ‘having’ clause and a ‘where’ clause?

0 Answers  

---