Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
- 1 Answers
- 4549 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
o A full database backup is a full copy of the database.
o A transaction log backup copies only the transaction log.
o A differential backup copies only the database pages
modified after the last full database backup.
o A file or filegroup restore allows the recovery of just
the portion of a database that was on the failed disk.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
what are the benefits of flashback feature?
how can you get actual data change values from previous transactions in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
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?
how can you implement fine-grained auditing?
internal architecture
How would you go about verifying the network name that the local_listener is currently using?
what are the performance views in an oracle rac environment?
what is the use of recording information about current session?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How would you extract DDL of a table without using a GUI tool?
What are the steps you will take to improve performance of a poor performing query?
Query processing is slow(eg select query)how will u solve that
