Solved

Master Db errors

Posted on 2007-11-20
3
254 Views
Last Modified: 2012-08-14
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
Msg 8906, Level 16, State 1, Line 1
Page (1:10) in database ID 8 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED   0_PCT_FULL'.
CHECKDB found 1 allocation errors and 0 consistency errors in table 'ALLOCATION' (object ID 99).
DBCC results for 'spt_monitor'.
There are 1 rows in 1 pages for object 'spt_monitor'.

any inputs
0
Comment
Question by:ohemaa
3 Comments
 
LVL 31

Expert Comment

by:James Murrell
ID: 20322667
0
 
LVL 3

Accepted Solution

by:
abhijit_k earned 500 total points
ID: 20334143
There seems to be a Problem with the Disk on which the Master Database Reside, you can move the master Database And run DBCC CheckDb again.
0
 

Author Comment

by:ohemaa
ID: 20350133
I am restoring the backup copy to a different server
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

Suggested Solutions

Title # Comments Views Activity
export sql results to csv 6 36
Help Required 3 97
divide by zero error 23 16
Merge two rows in SQL 4 15
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.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

803 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