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 view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is the importance of a recovery model? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
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?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
how can you enable flashback feature?
how can you create a user-defined lock?
What are statistics, under what circumstances they go out of date, how do you update them?
how does an oracle clusterware manage crs resources?
what is the role of dip user in our database?
What the different components in replication and what is their use? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
what are the benefits of flashback feature?