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

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,


What the different components in replication and what is their use? : sql server DBA

0 Answers  


You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  


How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  


How can you enable a trace for a session?

1 Answers  






What is a correlated sub-query? : sql server DBA

0 Answers  


How to determine the service pack currently installed on SQL Server?

1 Answers  


what are the differences of where and if in SAS?

0 Answers  


Hot backup procedure?

2 Answers  


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  


What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  


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

1 Answers  


Categories