what r the types of backup?

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

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  


Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,


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

0 Answers  


Give two methods you could use to determine what DDL changes have been made.

2 Answers  


what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,






what r the types of backup?

5 Answers   CSC,


In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  


What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,


How to make a replica of existing oracle server to another server?

3 Answers  


WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,


Categories