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 different types of database compression introduced in sql server 2008? : sql server DBA
what do you understand by fine-grained auditing?
what is the role of dip user in our database?
What authentication modes does sql server support? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is the default port no on which sql server listens? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
when does an alert gets signaled?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA