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
Which autogrowth database setting is good? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What happens on checkpoint? : sql server DBA
what is a crs resource?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Where do you find the default index fill factor and how to change it? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Explain materialized views and how they are used.
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what is the use of recording information about current session?
what is ora 24313?what is the procedure to exclude that error?
What is the default port no on which sql server listens? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
