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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories >> Software >> Databases >> SQL-Server
 
 
 
Question
Explian different types of BACKUPs avaialabe in SQL Server? 
Given a particular scenario, how would you go about 
choosing a backup plan? 
 Question Submitted By :: Swapna
I also faced this Question!!     Rank Answer Posted By  
 
Answer
different types of BACKUPS available in sql server are full 
database backup, differential database backup, 
transactional log backup, files and filegroup backup.
for new database we will go for full database backup, and 
if the the database is in full database backup type,then we 
do differential database backup or transactional log backup.
if the database size is too heavy means the database is 
VLDB then we go for files and filegroup database backup.
 
0
Raghuram
 
View All Answers
 
 
 
 
 
   
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