Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between off-line back up and on-line
back up in ibm db2 udb?
- 2 Answers
- 9008 Views
- Zenith, I also Faced
- E-Mail Answers
Answer Posted / vishal sharna
offline backup is the traditional backup in which we cannot
take the backup untill the application is closed but its
quite consistent,but as we know its very cost effective to
close all the application and then take the backup,so we
will take the online backup.in this case we an take the
backup of running aplication but set the recovery log mod
to rollforward,with the help of it we can restore our
database to the most recent state.
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
internal architecture
Why would you call update statistics? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is dbcc? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what functionality does oracle provide to secure sensitive information?
what is grd?
when does an alert gets signaled?
How do you trace the traffic hitting a sql server? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
