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
- 5409 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 view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are the different types of indexes available in sql server? : sql server DBA
Why would you call update statistics? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
Explain about your sql server dba experience? : sql server DBA
What is a system database and what is a user database? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how can you connect from 10g user to 11g user??
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the steps you will take to improve performance of a poor performing query?
when does an alert gets signaled?
what are the performance views in an oracle rac environment?
what is a user-defined lock?
