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

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,


what is logical system in sap basis

0 Answers  


Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  


What command would you use to encrypt a PL/SQL application?

1 Answers  


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 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  


i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,


now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,


what r the types of backup?

5 Answers   CSC,


How can we know the exact updation date of a particular database?

2 Answers   Satyam,


When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers  


how can you find out if a table can be redefined?

0 Answers   Oracle,


Categories