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 to delete a database in ms sql server?
How to run sql server 2005 books online on your local system?
Is sql server a database?
How to loop through the result set with @@fetch_status?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
What are synonyms?
What are the types of indexing?
What does the on update no action do?
How to delete existing rows in a table?
What are commit and rollback in sql?
Does an index slow down updates on indexed columns?
How to create a dynamic cursor with the dynamic option?
how we use window authentication connection with sql server.?
Explain unique key in sql server?
Describe and explain about SQL native client?