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 are the different types of upgrades that can be performed in sql server? : sql server DBA
Why would you use sql agent? : sql server DBA
what is a user-defined lock?
what is asm?
What is replication? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what do you understand by fine-grained auditing?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
how can you initialize log miner?
internal architecture
how can you implement fine-grained auditing?
what is the role of dip user in our database?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Where do you find the default index fill factor and how to change it? : sql server DBA