What are the different types of backup avaible in SQL SErver
- 6 Answers
- 10580 Views
- Emphasis, IBM, I also Faced
- E-Mail Answers
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 an indexed view?
Can one drop a column from a table?
What is a scheduled job or what is a scheduled task?
What are the different types of subquery?
What are the source of constraints?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Equi join and non equi join is possible with sql server?
List out the different types of locks available in sql server?
How raid can influence database performance?
What is the primary use of the model database?
How to rebuild the master database?
List the ways in which dynamic sql can be executed?
do you know how to configure db2 side of the application? : Sql server database administration
Why should you use or avoid select * statements?
How can you append an identity column to a temporary table?
