Solved

Boot page

Posted on 2013-01-22
2
168 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
ID: 38809389
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
ID: 38864867
i ve have some doubt, so currently reading some books to read and will come back to this answer
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

831 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