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
How do I start and stop sql server?
What is a trigger what are the advantages of trigger?
How to add code to the existing article (using improve article)?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is the sql case statement used for? Explain with an example?
How to delete multiple rows with one delete statement in ms sql server?
Where are sql server usernames and passwords stored in the sql server?
What is a document index?
Distinguish between commit and rollback?
What is the significance of master, tempdb and model databases?
What is an identity?
What are the advantages of the mirroring?
In case you have filters in your report, when filters will be applied in cached report instance?
What is the difference between varchar and varchar types?
between cast and convert which function would you prefer and why?