What are the different types of backup avaible in SQL SErver
Answer Posted / 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 |
Post New Answer View All Answers
What is transaction server consistency?
What is after dml trigger?
what is denormalization? : Sql server database administration
List all types of constraints in sql server?
What is sqlcmd?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is a fill factor?
what are the Prerequisites for Replication?
In what sequence sql statement is processed?
What is meant by datasource?
What is the use of nvl work?
What is a db view?
In which tcp/ip port does sql server run? Can it be changed?
What is a group function explain with an example?
What is xml datatype?