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
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How would you best determine why your MVIEW couldn't FAST REFRESH?
what are the differences of where and if in SAS?
how can you process messages in order asynchronously?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
what is the diffrence between core dba and apps dba?
what do you understand by fine-grained auditing?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what is grd?
what are the types of connection load-balancing?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA