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
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Why would you call update statistics? : sql server DBA
how can you implement fine-grained auditing?
Query processing is slow(eg select query)how will u solve that
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
what is a user-defined lock?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the commands used in dcl? : sql server DBA
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 are the steps you will take to improve performance of a poor performing query?
What is the difference between dropping a database and taking a database offline? : sql server DBA
what is grd?
How to start SQL Server in minimal configuration mode?
how can you record information about current session?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.