What are the types of backup and tell me the difference
between full and differential backup?
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 is a unique index?
What is stretch database in sql server?
Write an SQL query to obtain the 2nd highest salary.
What are diverse clauses that form a part of sql?
What is molap and its advantage? : sql server analysis services, ssas
what is a join and explain different types of joins? : Sql server database administration
What is the filtered index?
Is mysql better than sql server?
What are the extra roles available in msdb? : sql server security
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What is sql server query analyzer?
What is a self join in sql server?
How to convert numeric values to integers in ms sql server?
What are wait types?
What factors you will consider calculating the storage requirement for that view?