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
- 5524 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 fill factor? : sql server DBA
how can you record information about current session?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are statistics, under what circumstances they go out of date, how do you update them?
what is the role of dip user in our database?
how can you communicate with operating system files from oracle?
what is the use of ocr?
What are the different types of indexes available in sql server? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
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?
Why would you call update statistics? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
how does an oracle clusterware manage crs resources?
