Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

What is the difference between online backup & offline backup?

Question Posted / suman

Answer Posted / suman

we have two types of backups that is inconsist backup and
consistent backup
online backup is inconsistent backup
offline backup is consistent backuup
1.when the database is up on running at that time we have to
take the online backup it means hot backup
2.when the database is shutdown stage at that time we have
to take the offline backup it means cold backup this is the diff

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the default fill factor value? : sql server DBA

1059

What the different types of replication and why are they used? : sql server DBA

1104

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

4289

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

1885

how to restore files with rman?

2236

which background process invoke at the time of upgradation tell me???

2662

what is the use of ocr?

964

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1188

What is replication? : sql server DBA

1102

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?

2034

what are the benefits of flashback feature?

954

What would you do with an "in-doubt" distributed transaction?

1831

Explain about your sql server dba experience? : sql server DBA

1022

What the different topologies in which replication can be configured? : sql server DBA

1180

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

938