on 09-22-2011 9:58 AM
Hello!
I worked out sapnote 142731 but we are not able to restore, because the production has been working since two further days. Can anybody tells me how to repair the allocation errors?
Thank you in advance
Michael
The last checkdb give me this result:
dbcc checkdb (PL3)with no_infomsgs
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:1031296) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:1038336) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
CHECKDB found 2 allocation errors and 0 consistency errors not associated with any single object.
CHECKDB found 2 allocation errors and 0 consistency errors in database 'PL3'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PL3 ).
Hello!
Thank you very much for your reply!
Last weekend a had a downtime. So I used it for the following repair:
use <SID>
exec sp_dboption '<SID>,'single user','TRUE'
DBCC CHECKDB ('<SID>', repair_allow_data_loss)
exec sp_dboption '<SID>','single user','FALSE'
GO
It ran fully successfull.
This time we were quite lucky under these circumstances.
Best Regards
Michael Andreas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> Server: Msg 8905, Level 16, State 1, Line 1
> Extent (1:1031296) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
> Server: Msg 8905, Level 16, State 1, Line 1
> Extent (1:1038336) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
> CHECKDB found 2 allocation errors and 0 consistency errors not associated with any single object.
> CHECKDB found 2 allocation errors and 0 consistency errors in database 'PL3'.
> repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PL3 ).
I would open an OSS call and attach that information to the message. The SQL server support group should check that error.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.