Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
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 is asm?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What are the recovery models for a database? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are the different sql server versions you have worked on? : 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.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
How to start SQL Server in minimal configuration mode?
What are the different types of indexes available in sql server? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
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.
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?