what r the types of backup?

Categories >> Software >> Databases >> DB Administration
Suggest New Category

Question Posted / kittu_chintu2005

5 Answers
7014 Views
CSC, I also Faced
E-Mail Answers

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 we see the database version in os level

6 Answers Oracle,

what is the difference between hot backup n rman backup?

1 Answers Value Labs,

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers Oracle,

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers

what are the types of connection load-balancing?

0 Answers Oracle,

How would you go about increasing the buffer cache hit ratio?

2 Answers

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers

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

2 Answers Satyam,

what is the role of dip user in our database?