Interested to Buy Any Domain ? << Click Here >> for more details...
what r the types of backup?
- 5 Answers
- 7411 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 |
What are the different types of indexes available in sql server? : sql server DBA
How would you determine what sessions are connected and what resources they are waiting for?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Where would you look for errors from the database engine?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the different ways of moving data or databases between servers and databases in SQL Server?
What are the steps you will take, if you are tasked with securing an SQL Server?
why Datapump is faster than traditional export and import
how will u see whether the dabase is in archive log mode or not?
How would you determine who has added a row to a table?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Why would you use sql agent? : sql server DBA
-
Oracle (3253) - 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)
