Type of backup 1. Normal backup(A complete set of all files you wish to

what r the types of backup?

Question Posted / mahinder singh

5 Answers
7414 Views
CSC, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

what are the benefits of flashback feature?

1092

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1060

What are the recovery models for a database? : sql server DBA

1181

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

4411

how can you schedule a job in database?

1192

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2687

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

1998

who owns the operating system files created by the utl_file package?

1125

What is the difference between dropping a database and taking a database offline? : sql server DBA

1111

What is the difference between clustered and non-clustered index? : sql server DBA

1147

internal architecture

2255

What authentication modes does sql server support? : sql server DBA

1265

what is asm?

1116

how can you create a user-defined lock?

1058

What is fill factor? : sql server DBA

1309