Solved

Boot page

Posted on 2013-01-22
2
165 Views
Last Modified: 2013-11-07
What does the boot page contain and why it's being used?If it's not present,what will be the problem?
0
Comment
2 Comments
 
LVL 15

Accepted Solution

by:
Anuj earned 100 total points
Comment Utility
A boot page is page 9 in file 1 of each database, this has critical information about the database like last good DBCC run time, Log Reuse details, Last backup time, database version information along with other details. If this page goes corrupted, database will not start-up the only option you left with is to do a database restore.
0
 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
Comment Utility
i ve have some doubt, so currently reading some books to read and will come back to this answer
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now