June 12, 2015 at 8:03 pm
Hi,
When I run dbcc checkdb
Msg 2576, Level 16, State 1, Line 1
The Index Allocation Map (IAM) page (0:0) is pointed to by the previous pointer of IAM page (1:217925) in object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594296401920 (type Unknown), but it was not detected in the scan.
Msg 2575, Level 16, State 1, Line 1
The Index Allocation Map (IAM) page (1:54347) is pointed to by the next pointer of IAM page (0:0) in object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594296401920 (type Unknown), but it was not detected in the scan.
CHECKDB found 2 allocation errors and 0 consistency errors not associated with any single object.
What I have to do?
June 12, 2015 at 8:06 pm
Even when I run
DBCC CHECKDB ('DBNAME', NOINDEX)
I am getting the same errors.
How to fix this issue?
June 12, 2015 at 8:38 pm
Paul Randal has a blog post about this sort of missing metadata case here: http://www.sqlskills.com/blogs/paul/iam-page-corruption-examples/
Per his advice in the comments to that article, you will need to either restore from a valid backup or run a repair and risk some data loss.
June 12, 2015 at 11:02 pm
If we take the database offline without resolve (Without run the dbcc check db allow repairdataloss) the issue. Does it still generates the dump files?
June 13, 2015 at 5:45 am
DO NOT take the database offline!
Please post the full and complete, unedited output of
DBCC CheckDB('<Database name>') WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have a clean backup?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 13, 2015 at 6:49 pm
I don't have clean backup.
The same database has in two servers. I run dbcc checkdb allow dataloss in one server, where we are using currently the database. We are getting dump files in both servers. Now the dump files generation is stopped in this server but we are not using this database in another server that's where we want to take database offline.
We just need to stop the dump files generation, we don't care about the cleaning the db in that server. So is that ok to take db offline?
June 14, 2015 at 8:47 am
If you don't care about the database, drop it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 14, 2015 at 10:06 am
GilaMonster (6/14/2015)
If you don't care about the database, drop it.
+1
June 15, 2015 at 3:19 am
GilaMonster (6/14/2015)
If you don't care about the database, drop it.
+100000000
June 17, 2015 at 10:41 am
Is there any way to get notify from sql server when the dump files are getting created?
June 18, 2015 at 2:04 am
ramana3327 (6/17/2015)
Is there any way to get notify from sql server when the dump files are getting created?
Do you mean backups? These are noted in the log, there are trace/events you can monitor as well.
June 18, 2015 at 4:33 pm
No I am talking about the dumpfiles
declare @dump int
select @dump= count(1)
from (SELECT * from sys.dm_server_memory_dumps
where cast(creation_time as date)=getdate() ) xx
IF @dump > 0
BEGIN
EXEC msdb.dbo.sp_send_dbmail
@recipients=N'ramana@yahoo.com',
@body='DumpFilesAuditing',
@subject ='DumpFiles Created in Server ',
@profile_name ='SqlProfile'
END
I am planning to run every 1hr but
Question1: How to display the server name where the job is running here?
Question2: Is it better to avoid indexes on production db while running dbcc checkdb or includes the index? This db is configured for replication and one of the table will in use 24/7
June 23, 2015 at 10:35 am
Q1: @@servername contains the name of the instance. Include that in your subject or message.
Q2: doesn't make sense. What do you mean by avoid indexes?
June 23, 2015 at 12:58 pm
Steve Jones - SSC Editor (6/23/2015)
Q1: @ @servername contains the name of the instance. Include that in your subject or message.Q2: doesn't make sense. What do you mean by avoid indexes?
I believe he means using the NOINDEX OPTION when running the check In my opinion, it's okay to skip the checks for the NCI's from time-to-time (like daily) but I would recommend running the the full blown check at least 1/week - just an opinion though 😀
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply