Interested to Buy Any Domain ? << Click Here >> for more details...
what r the types of backup?
- 5 Answers
- 7245 Views
- CSC, I also Faced
- E-Mail Answers
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 |
How do you add a data file to a tablespace?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is the difference between the SQL Loader and IMPORT utilities?
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
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
what is a crs resource?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the commands used in dcl? : sql server DBA
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
-
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)
