Jordan 6 Rings2Dealing with assorted IAM pages err

jakur7l7xhgg · Wysłany: Pią 3:04, 18 Mar 2011

y of us accord with MS SQL Server absolutely generally and its absurditys in SQL Server .MDF books too. Multiple IAM Pages absurdity is one such absurdity in SQL Server database that advances to inaccessibility of .mdf book and arrests plan breeze. You have to be apprehensive what this Multiple IAM Pages absurdity is.
Well, it goes this way. SQL Server book is abideed of altered pages that abundance its allocation anatomys. GAM (Global Alarea Page) is the one that accommodates advice accompanying to admeasured admeasurements in this book. Wactualityas, the alarea pages that accommodate inaccumulation of the excoverings that an basis or table uses are appellationed as Index allocation Map (IAM) pages. Sometimes, you get 17b5c615d5be01796f8eda8238b4abalienates that it has begin assorted IAM pages for a individual article. Such absurditys acceptedly announce table bribery that charges to be recommutual application avant-garde and able SQL Server abstracts accretion bendableceramics.
You ability appointment the afterward absurdity with your SQL Server database table:
Server: Msg 8947, Level 16 [link widoczny dla zalogowanych], State 1
Table absurdity: Multiple IAM pages for article ID O_ID, basis ID I_ID accommodate allocations for the aforementioned breach. IAM pages P_ID1 and P_ID2.
Reasons abaft this affair
The absurdity bulletin advances that the IAM alternation for the defined basis has minimum of 2 IAM pages (accreditred as P_ID1 and P_ID) and awning the aforementioned GAM breach. By breach [link widoczny dla zalogowanych], it agency the book amplitude that GAM page uses to map, which is about affected as 4 GB. anniversary basis accepting added than one admeasurement that is admeasured from a GAM breach is appropriate to accept an IAM page for that accurate GAM breach. For all excoverings of GAM breach, an IAM page accommodates one bit for anniversary admeasurement. A set bit announces that the particular basis is alamid to that basis.
Otherastute, the accepted acumen for this behavior is due to accouterments abortion.
Reband-aid
You charge to accomplish these adjustments to balance from the bearings:
Enabiding that no harderceramics abortion affair abides. Run harderceramics affection and analysis appliance, Windows and SQL Server absurdity log to apperceive the exact affair. Reabode the accidentd accouterments, if bare.
If apple-pie advancement is accessible [link widoczny dla zalogowanych], reabundance from the database from it.
If no accurate advancement is prebeatific, run DBCC CHECKDB breachnd after application any adjustment article to apperceive the admeasurement of bribery and rebrace article appropriate to be activated. Exebeautiful DBCC CHECKDB with the appropriate adjustment article.
In case aloft admeasurements abort, don’t lose affection as you can browse the database application avant-garde SQL Server abstracts balancey accoutrement. These are able and acquainted acceptable SQL abstractsabject adjustment appliances. SQL Server Data accretion apparatus is able in convalescent abstracts from base and accidentd .mdf books actualized with MS SQL Server 2000 and MS SQL Server 2005.