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 the different types of replication and why are they used? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What is the importance of a recovery model? : sql server DBA
What is the default fill factor value? : sql server DBA
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?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What is replication? : sql server DBA
how can you communicate with operating system files from oracle?
Can you redefine a table online?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What types of replication are supported in sql server? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?