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 are the types of sql server?
How do I create a partition table in sql server?
Do you know what is a trace frag? Where do we use it?
What are the restrictions that views have to follow?
How to change the name of a database user?
How to encrypt Strored Procedure in SQL SERVER?
What do you mean by authentication modes in sql server?
How to create new tables with "create table" statements in ms sql server?
Difference between 2NF &3NF ?
What is the difference between dropping a database and taking a database offline?
What is raid and what are different types of raid levels?
What is 3nf normalization form?
Explain table valued parameters in sql server? Why tvp used?
Explain the difference between primary keys and foreign keys?
What are different types of schemas?