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
how can you communicate with operating system files from oracle?
What the different components in replication and what is their use? : sql server DBA
what functionality does oracle provide to secure sensitive information?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how can you connect from 10g user to 11g user??
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Why would you use sql agent? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can you initialize log miner?
What would you do with an "in-doubt" distributed transaction?
How would you best determine why your MVIEW couldn't FAST REFRESH?
How would you extract DDL of a table without using a GUI tool?
How do you trace the traffic hitting a sql server? : 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?