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
What would you do with an "in-doubt" distributed transaction?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
how to restore files with rman?
Query processing is slow(eg select query)how will u solve that
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?
what do you understand by fine-grained auditing?
how can you initialize log miner?
What is the default fill factor value? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
what is the use of ocr?
what is the diffrence between core dba and apps dba?
how can you process messages in order asynchronously?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
how can you record information about current session?
What is replication? : sql server DBA