what is differencial backup?how to work?Anybody explai it?
Answers were Sorted based on User's Feedback
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 |
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 |
What is transact-sql language?
Do you know what are the restrictions that views have to follow?
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
hi,i want t0 knom d syntax for a super key with an example
wat is tuff file in log shipping, wt is d use of tht file?
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
How to convert numeric expression data types using the cast() function?
Does server sql treat char as a variable-length or fixed-length column?
Can anybody explain me cold backup and hot backup?
What is resource governor in sql server?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
Can you tell me the difference between DELETE & TRUNCATE commands?