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
how can u get last observation in an unknown dataset ?
What are the steps you must follow to hide sql server instances?
Is truncate a dml command?
How to check if a table is being used in sql server?
What is b tree index?
Explain about nested stored procedure?
Tell me what is de-normalization and what are some of the examples of it?
How data can be copied from one table to another table?
do you know how to configure db2 side of the application? : Sql server database administration
what are the critical issues you have resloved in your company
Explain features and concepts of analysis services?
Is it possible for a stored procedure to call itself or recursive stored procedure?
what is a check constraint?
When multiple after triggers are attached to sql table, how to control the order of execution?
Explain the use of containers in ssis and also their types?