ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
What are the types of backup and tell me the difference 
between full and differential backup?
 Question Submitted By :: Mirjawad
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are the types of backup and tell me the difference between full and differential backup?
Answer
# 1
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 ?    3 Yes 1 No
Rajvelur
 
  Re: What are the types of backup and tell me the difference between full and differential backup?
Answer
# 2
Full backup
Differntail backup
Transcation log backup
File & Filegroup backup

Full backup : it's take full database
differential backup : what are the changes made after 
fullbackup to current backup is called differntial backup
 
Is This Answer Correct ?    2 Yes 1 No
Hari
 
 
 
  Re: What are the types of backup and tell me the difference between full and differential backup?
Answer
# 3
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 ?    0 Yes 0 No
Raghuram
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? HCL1
Wht is Stuff in sql ser  1
What is blocking and how would you troubleshoot it? HCL1
What are the advantages of using sql server over ms access or why should one use sql instead of ms access Impetus1
which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM Wipro4
Different Types of Functions ? Satyam2
What is Trigger? Misys2
Where do you think the users names and passwords will be stored in sql server?  2
What are statistics, under what circumstances they go out of date, how do you update them? HCL2
1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them? Techno-Solutions1
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no. iFlex2
What is referential integrity? What are the advantages of it? Digital-Domain2
what is differece between union and union all  3
What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance.... Siemens6
When do you use SQL Profiler?  2
how to implement locking in sql server Satyam1
UPDATE statement can on a single table or on the multiple table? iGate3
how can do you the system monitoring?  1
select empid empname from employee What is the result for the about query?  3
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?  1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com