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

A left outer join B B right outer join A gives the same result then what is the use of two?

1 Answers  

How to find the service pack installed? : sql server database administration

0 Answers  

what is Constraint? How many types of constraints in SQL ?

38 Answers   HCL, IBM, NIIT, Wipro,

What is coalesce and check constraint in sql server?

0 Answers  

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

0 Answers  

How can i change the column name.

13 Answers   HCL, Yardi Software,

What is the difference between UNION and UNIONALL?

5 Answers   CarrizalSoft Technologies, CTS,

Can we use having clause without group by?

0 Answers  

What is ddl and dml commands?

0 Answers  

Does partitioning help performance?

0 Answers  

Repair mdf file

2 Answers  

What is the difference between a check constraint and a rule?

0 Answers