Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?



Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would..

Answer / guest

o A full database backup is a full copy of the database.
o A transaction log backup copies only the transaction log.
o A differential backup copies only the database pages
modified after the last full database backup.
o A file or filegroup restore allows the recovery of just
the portion of a database that was on the failed disk.

Is This Answer Correct ?    3 Yes 3 No

Post New Answer

More DB Administration Interview Questions

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,


What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  


How many packages we have in db

1 Answers   Tesco,


Which autogrowth database setting is good? : sql server DBA

0 Answers  


Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  






how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,


CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,


Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  


1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  


how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,


if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  


hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,


Categories