Interested to Buy Any Domain ? << Click Here >> for more details...
Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
- 1 Answers
- 5442 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 is the default port no on which sql server listens? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
What is a correlated sub-query? : sql server DBA
What are the recovery models for a database? : sql server DBA
how can you communicate with operating system files from oracle?
What is a system database and what is a user database? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What is dbcc? : sql server DBA
what is the use of ocr?
What types of replication are supported in sql server? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What the different components in replication and what is their use? : sql server DBA
