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 snapshot parameter in ssrs?
What is use of dbcc commands?
Do you know how to make remote connection in database?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Explain alternate key, candidate key and composite key in sql server?
What is a raid and what are different types of raid configurations?
Explain the difference between cross join and full outer join?
What are click through reports?
Explain database normalization?
How can you check the level of fragmentation on a table?
What is log cache in sql server?
How to insert multiple rows with one insert statement in ms sql server?
What is Service Broker in sql server 2012?
What is a full text index?
What is side by side migration in sql server?