Answer Posted / rohit bhosale
In SQL server 2008 we have following types of backup:
1. full backup
2. differential backup
3. transaction log backup
4. tail log backup
5. mirror backup
6. Partial backup
7. copy only backup
8. split backup
9. compressed backup
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
You create a private database link and upon
connection, fails with: ORA-2085: connects to
How would you extract DDL of a table without using a GUI tool?
Can you redefine a table online?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Why would you use sql agent? : sql server DBA
what is the role of dip user in our database?
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.
what is logical system in sap basis
what is grd?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are the recovery models for a database? : sql server DBA
what do you understand by fine-grained auditing?
how can you enable flashback feature?