Answer Posted / raghuram

different types of BACKUPS available in sql server are full
database backup, differential database backup,
transactional log backup, files and filegroup backup.
for new database we will go for full database backup, and
if the the database is in full database backup type,then we
do differential database backup or transactional log backup.
if the database size is too heavy means the database is
VLDB then we go for files and filegroup database backup.

How many replicas are maintained for each SQL Azure database?

142

---

Explain the concepts and capabilities of sql server?

967

---

What are scalar functions?

994

---

What new changes are being made in SQL Server?

1178

---

What are the key configuration files for sql server reporting services ?

167

---

What happens if ntwdblib.dll is missing on your machine?

1140

---

How to create user messages with print statements in ms sql server?

983

---

How to get the definition of a trigger back?

998

---

What are the different types of indexes?

1110

---

What are the benefits and tasks of object explorer? : sql server management studio

1175

---

How is table type constraint applied to a table?

973

---

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

938

---

Can you explain what is indexed view? How to create it?

893

---

What will be the maximum number of indexes per table?

955

---

How to drop an existing table?

1000

---