1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / guest


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

Name a tablespace automatically created when you create a database.

5 Answers  

What types of replication are supported in sql server? : sql server DBA

0 Answers  

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

What would you do with an "in-doubt" distributed transaction?

0 Answers  

What is replication? : sql server DBA

0 Answers  




How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

what is asm?

0 Answers   Oracle,

what is meant by gateway

1 Answers   IBM,

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

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

0 Answers   Oracle,

What is the importance of a recovery model? : sql server DBA

0 Answers  

what is a crs resource?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories