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

what r the types of backup?

Question Posted / kittu_chintu2005

Answers were Sorted based on User's Feedback



what r the types of backup?..

Answer / kittu_chintu2005

logical backup: export/import from 10g datapump
physical backup: cold backup, hot backup & RMAN backup

Is This Answer Correct ?    5 Yes 1 No

what r the types of backup?..

Answer / srinivas

In sqlserver 8 types of backups

1. full backup
2. differential backup
3. transaction log backup
4. tail log backup
5. mirror backup
6. file and file group backup
7. copy only backup
8. partial backup

Is This Answer Correct ?    2 Yes 0 No

what r the types of backup?..

Answer / rohit bhosale

In SQL server 2008 we have following types of backup:

1. full backup
2. differential backup
3. transaction log backup
4. tail log backup
5. mirror backup
6. Partial backup
7. copy only backup
8. split backup
9. compressed backup

Is This Answer Correct ?    2 Yes 0 No

what r the types of backup?..

Answer / mahinder singh

Type of backup

1. Normal backup(A complete set of all files you wish to
back up. Think of this as your 'reference set'. You only
need perform a full backup occasionally.)

2. copy backup(A complete set of all files you wish to
back up. Think of this as your 'reference set'. You only
need perform a full backup occasionally.)

3. incremental backup(A backup of those files which have
changed since the last backup of any type.)

4. differential backup(A backup of those files which have
changes since the last full backup. Should be performed at
regular intervals.)

Is This Answer Correct ?    2 Yes 1 No

what r the types of backup?..

Answer / suman

three types of backups that is
1.physical backup:cold backup and hot backup
2.logical backup: export/import utility provided by oracle
3.Rman backup

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB Administration Interview Questions

how can you connect from 10g user to 11g user??

0 Answers   HP,

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  




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

2 Answers   CSC,

how can you initialize log miner?

0 Answers   Oracle,

Explain materialized views and how they are used.

0 Answers  

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

how can you schedule a job in database?

0 Answers   Oracle,

What is the difference between Datapump & export/import?

2 Answers  

what is rebuild index??

2 Answers   IBM, Sapient,

For more DB Administration Interview Questions Click Here
Categories