Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of backup and tell me the difference
between full and differential backup?
- 4 Answers
- 13788 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
Explain what are the restrictions while creating batches in sql server?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is used to replicate sessions between instances in coldfusion clusters?
How to list all tables in the database using odbc_tables()?
How to create new table with "create table" statements?
How do I edit a stored procedure in sql server?
What are system databases into sql server (2005/2008) : sql server database administration
Explain full-text query in sql server?
What is replace and stuff function in sql server?
Explain activity monitors
How do you manipulate data?
How to Check if table exists in sql server?
What are the differences between substr and charindex in sql server.
Explain four layers of abstraction microsoft architectured?
Explain different types of self contained sub query?
