what r the types of backup?

Answer Posted / srinivas

In sqlserver 8 types of backups

1. full backup
2. differential backup
3. transaction log backup
4. tail log backup
5. mirror backup
6. file and file group backup
7. copy only backup
8. partial backup

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the diffrence between core dba and apps dba?

2087


What is a correlated sub-query? : sql server DBA

579


how can you schedule a job in database?

595


How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1653


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1491






In what script is "snap$" created? In what script is the "scott/tiger" schema created?

1946


what are the performance views in an oracle rac environment?

557


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

1898


i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

1637


What are the different ways you can create databases in sql server? : sql server DBA

596


What are the different types of upgrades that can be performed in sql server? : sql server DBA

678


A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

1998


what is the use of recording information about current session?

566


internal architecture

1755


What is the default port no on which sql server listens? : sql server DBA

556