Answer / hari

Full Backup
Differential backup
Transcational log backup

Answer / senthilkumar

SQL Server provides several different kinds of backups
including Complete Backup, Differential Backup, Transaction
Log Backup, and File(s) and Filegroup(s) backup.

Answer / amit kumar

Full - backups entire database
Differential - backups all changes since last full backup
Transaction Log - backups transaction log for all changes
since last transaction log backup
File - allows you to backup one data file
Filegroup - allows you to backup an entire filegroup

Answer / devender reddy

The different types of backups in SQL Server are following:

Full Backup
Differential backup
Transcational log backup

Answer / koti

full,
differential,
transactional,
file group:-it is a backup in which the large databases are
separated as file groups. this is used in high level
organizations.

Answer / pavan

full
differential
transaction
taillog
copy_only
mirror
files and file group
partial

List the types of recovery model available in sql server?

1 Answers  

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1 Answers  

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

What is the difference between system objects and user objects?

1 Answers   HCL,

What is a schema in ms sql server 2005?

1 Answers  

Explain the disadvantages/limitation of the cursor?

1 Answers  

What are the types of table?

1 Answers  

What is the use of keyword with encryption. Create a store procedure with encryption?

1 Answers  

Is Sql non procedural query language?

1 Answers   Verifone,

Does partitioning help performance?

1 Answers  

how do we find every fifth record in a table

14 Answers   Aspire, HCL,

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers