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

Can you redefine a table online?

0 Answers   Oracle,


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

0 Answers  


Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  


Explain the use of table functions.

1 Answers  


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  






what is a crs resource?

0 Answers   Oracle,


how can you create a user-defined lock?

0 Answers   Oracle,


one datafile is lost in standy side how can you recover that??

2 Answers  


i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,


what are the differences of where and if in SAS?

0 Answers  


What is dbcc? : sql server DBA

0 Answers  


What is transparent data encryption? : sql server DBA

0 Answers  


Categories