what r the types of backup?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
what is the use of home directory???
how can you initialize log miner?
You have just compiled a PL/SQL package but got errors, how would you view the errors?
Which environment variables are absolutely critical in order to run the OUI?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
Which autogrowth database setting is good? : sql server DBA
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?
What is replication? : sql server DBA
orra 1555 what is this error,why it is occur?
why we use cursors
Explain materialized views and how they are used.
When a user process fails, what background process cleans up after it?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)