Answer / swapna

Types of backups you can create in SQL Sever 7.0+ are Full
database backup, differential database backup, transaction
log backup, filegroup backup.

Answer / 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.

Can we write ddl in trigger?

0 Answers  

---

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  

---

what is the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

---

Explain fundamentals of Data ware housing & OLAP?

2 Answers  

---

Can we take the full database backup in log shipping?

0 Answers  

---

---

What are the different types of stored procedures?

0 Answers  

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

---

Define Unique Key?

0 Answers   HCL,

---

What is the maximum length of an alert name?

0 Answers  

---

How to reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,

---

How many types of cursor type are there?

0 Answers  

---

Explain tablesample?

0 Answers  

---