What are the types of backup and tell me the difference
between full and differential backup?
- 4 Answers
- 12336 Views
- CTS, TCS, I also Faced
- E-Mail Answers
Answer Posted / rajvelur
Full Backups include all data within the backup scope. For
example, a full database backup will include all data in the
database, regardless of when it was last created or
modified. Similarly, a full partial backup will include the
entire contents of every file and filegroup within the scope
of that partial backup.
Differential Backups include only that portion of the data
that has changed since the last full backup. For example, if
you perform a full database backup on Monday morning and
then perform a differential database backup on Monday
evening, the differential backup will be a much smaller file
(that takes much less time to create) that includes only the
data changed during the day on Monday.
| Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
What kind of problems occurs if we do not implement proper locking strategy?
What is the purpose of object explorer and its features? : sql server management studio
What is encryption key?
Do you know what is difference between stored procedure and user defined function?
What are triggers in ms sql server?
Explain what is the function of sql server agent windows service?
What is the maximum length of an alert name?
How many types of built in functions are there in sql server 2012?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What are the characteristics of modern DBMS?
What are horizontal and vertical scaling?
How to create a view using data from another view?
What is temporary table in sql server? Why we use temp table?
How to change a login name in ms sql server?
How will you optimize a stored procedure optimization?
