What are the different types of backup avaible in SQL SErver

Answers were Sorted based on User's Feedback



What are the different types of backup avaible in SQL SErver..

Answer / hari

Full Backup
Differential backup
Transcational log backup

Is This Answer Correct ?    18 Yes 2 No

What are the different types of backup avaible in SQL SErver..

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.

Is This Answer Correct ?    11 Yes 1 No

What are the different types of backup avaible in SQL SErver..

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

Is This Answer Correct ?    8 Yes 1 No

What are the different types of backup avaible in SQL SErver..

Answer / devender reddy

The different types of backups in SQL Server are following:

Full Backup
Differential backup
Transcational log backup

Is This Answer Correct ?    5 Yes 1 No

What are the different types of backup avaible in SQL SErver..

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.

Is This Answer Correct ?    1 Yes 1 No

What are the different types of backup avaible in SQL SErver..

Answer / pavan

full
differential
transaction
taillog
copy_only
mirror
files and file group
partial

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More SQL Server Interview Questions

Does sql server use t sql?

0 Answers  


what is hash nonclustered index

0 Answers  


How to drop an existing stored procedure in ms sql server?

0 Answers  


what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?

2 Answers  


What is raid, and how it can influence database performance?

0 Answers  






What is indexing?

0 Answers   AOL,


How will you monitor replication latency in transactional replication? : sql server replication

0 Answers  


What is the difference between executequery () and executeupdate ()?

0 Answers  


What is the use of group by clause?

0 Answers  


What is Files and Filegroups in SQL Server & it's implementation.

1 Answers   Zenith,


In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,


What are different types of collation sensitivity?

0 Answers  


Categories