What is the difference between online backup & offline backup?
Answer Posted / kittu_chintu2005
online backup: 1) inconsistent backup 2) database must be in archive log mode 3) database should be in upon running
offline backup: 1) consistent backup 2)database may be or may not be in archive log mode 3)database should in shut down state
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what is asm?
how can you initialize log miner?
Can you redefine a table online?
what functionality does oracle provide to secure sensitive information?
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.
How would you best determine why your MVIEW couldn't FAST REFRESH?
how can you process messages in order asynchronously?
who owns the operating system files created by the utl_file package?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
what is logical system in sap basis
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