What are the types of backup and tell me the difference
between full and differential backup?
Answer Posted / raghuram
the types of backup are
full database backup
differential database backup
transactional log backup
file and filegroup backup
the difference between full and differential backup is in
full backup it takes backup for entire database including
transactional log files. but in diffrential database backup
it take only the changes happened between full database
backup and current backup.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
what's new in sql server 2016?
What are the advantages of policy management?
How to insert a new row into a table with "insert into" statements in ms sql server?
Explain isolation levels that sql server supports?
What is forward - only cursors / read only cursor?
What is checkpoint in sql server?
What are the advantages of passing name-value pairs as parameters?
What are the differences between char and varchar in ms sql server?
Can two tables share the same primary key?
what is the difference between count(*) and count(1) ?
What sql server means?
What is intellisense?
What command is used to create a database in the sql server and how?
Differentiate between SQL and ORACLE joins and write their syntax.
What is the usage of sign function?