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 incremental checkpoint?

Question Posted / shwetha

Answer Posted / shwetha

During normal running of database, dirty buffers are added
to checkpoint queue.Also when a block is first modified it
is entered in the checkpoint queue.The RBA of redo record
is also added.Every 3 sec CKPT records the RBA from
checkpoint queue.In case of instance failure RBA gives the
location from where recovery has to start( Checkpoint
position). During log switch CKPT updates contrl file and
data file headers.

Is This Answer Correct ?    4 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1053

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1042

what is a crs resource?

1110

What are statistics, under what circumstances they go out of date, how do you update them?

2195

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2397

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2640

Why would you call update statistics? : sql server DBA

946

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1699

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1919

What purpose does the model database server? : sql server DBA

1095

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2134

What authentication modes does sql server support? : sql server DBA

1134

What is the difference between clustered and non-clustered index? : sql server DBA

1023

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2043

Which autogrowth database setting is good? : sql server DBA

1050