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  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
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 ?    7 Yes 2 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 ?    6 Yes 2 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 ?    3 Yes 1 No
Raghuram
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
how to rest identity columns in sql server Matrix3
What are the different ways of moving data/databases between servers and databases in SQL Server? HCL2
How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS? GE1
Whether the updations made to the views reflect the original records in the table NIIT5
What is Peer to peer Replication? HCL1
What is the difference between having and where clause?  4
About types of indexes in SQL server ? Cognizent1
What is normalization and what are the different forms of normalizations?  1
How can u convert the Date to String? TCS4
Can we create a clustered index on composite primary key.  2
write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?  7
Can a stored procedure call another stored procedure. If yes what level and can it be controlled?  2
hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.  2
What is a materialized view?  2
I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?  1
what is a cursor and what is its use?  1
How will u find the query which is running in some other machine IBM2
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? Yardi-Software4
is there more the two primary key in a single table? Systematix22
Can you give an example of Stored Procedure?  2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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