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 are three major types of constraints?
How do I find the sql server instance name?
How many clustered indexes there can be on table ?
What are page splits?
What is dbcc command in sql server?
How to insert stored procedure result into temporary table?
What are truncate options available in sql server? : sql server database administration
How do I create a partition table in sql server?
What are dml triggers and types of dml triggers?
what is raid and what are different types of raid configurations? : Sql server database administration
How to automatically create a log when an exception is being received into SQL Server?
When is the use of update_statistics command?
Would you store your query in a ssrs report or a database server? State the reason why?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What is tempdb database? : SQL Server Architecture