what is differencial backup?how to work?Anybody explai it?

Answers were Sorted based on User's Feedback



what is differencial backup?how to work?Anybody explai it? ..

Answer / dharmesh tandel

Differential Back: Only those files will be included which
have been changed since the last FULL backup.

http://www.orionsoftlab.com/backup/backup_anywhere.gif

Is This Answer Correct ?    13 Yes 0 No

what is differencial backup?how to work?Anybody explai it? ..

Answer / pradeepreddy

differential backup backups only changes made in the
database on to backup media since the last full backup

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is transact-sql language?

0 Answers  


Do you know what are the restrictions that views have to follow?

0 Answers  


you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

0 Answers  


hi,i want t0 knom d syntax for a super key with an example

1 Answers  


wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,






1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

0 Answers   CSC, IBM,


How to convert numeric expression data types using the cast() function?

0 Answers  


Does server sql treat char as a variable-length or fixed-length column?

0 Answers  


Can anybody explain me cold backup and hot backup?

3 Answers   TCS,


What is resource governor in sql server?

0 Answers  


What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

0 Answers  


Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  


Categories