What are the different types of backup avaible in SQL SErver
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Answer / pavan
full
differential
transaction
taillog
copy_only
mirror
files and file group
partial
Is This Answer Correct ? | 1 Yes | 5 No |
Does sql server use t sql?
what is hash nonclustered index
How to drop an existing stored procedure in ms sql server?
what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?
What is raid, and how it can influence database performance?
What is indexing?
How will you monitor replication latency in transactional replication? : sql server replication
What is the difference between executequery () and executeupdate ()?
What is the use of group by clause?
What is Files and Filegroups in SQL Server & it's implementation.
In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
What are different types of collation sensitivity?