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

Why use update_statistics command in sql server?

0 Answers  

Define synonym?

0 Answers  

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

Explain transaction server isolation?

0 Answers  

What is table value parameters (tvp)?

0 Answers  

Does union all remove duplicates?

0 Answers  

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  

What do you mean by recursive stored procedure?

0 Answers  

What do you understand by triggers?

0 Answers  

Can we drop user if user mapped to any logins

1 Answers  

What are various limitations of the views?

0 Answers  

Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers