Answer Posted / shardul negi

backup database <database name> to disk
= 'c:\<DatabaseName>.bak'

Is there any difference between primary key and unique with the not null condition?

702

---

What is the difference between migration and upgradation in sql server?

786

---

What is the difference between join and inner join?

721

---

Explain what is sql server english query?

723

---

Can I save my report as html, excel or word? : sql server management studio

726

---

---

How to resolve the orphan use problem? : sql server security

707

---

What is simple indexing method?

748

---

Differentiate sql server reporting services vs. Crystal reports?

166

---

What is the purpose of optimization?

720

---

why would you use sql agent? : Sql server database administration

766

---

Where sql server usernames and passwords are stored in a sql server?

659

---

In which sql server version report builder introduced?

125

---

Where is my database stored on the hard disk in ms sql server?

769

---

how you can get the list of largest tables in a database? : Sql server administration

723

---

How to access the inserted record of an event?

772

---