Answer Posted / 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 |
Post New Answer View All Answers
what are the benefits of flashback feature?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are the recovery models for a database? : sql server DBA
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
how can you schedule a job in database?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
who owns the operating system files created by the utl_file package?
What is the difference between dropping a database and taking a database offline? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
internal architecture
What authentication modes does sql server support? : sql server DBA
what is asm?
how can you create a user-defined lock?
What is fill factor? : sql server DBA