SQL-Datenbank retten? (Nicht aus WaWi)

knuddel256

Aktives Mitglied
13. Juli 2009
19
0
Hallo zusammen,

das Thema gehört zwar eigentlich nicht hier hinein, weil es nicht die Wawi betrifft, könnte aber von der technischen Betrachtung her doch auf die Wawi übertragbar sein.

Wir betreiben in unserer kleinen Spedition ein Netzwerk mit einem Small Business Server 2008. Hier setzen wir im Netzwerk auch die Microsoft Sharepoint Services 3.0 ein, um eine Art Intranet zu betreiben und allerlei Daten firmenintern bereitzustellen.

Am 11.07.10 ist unser Server hitzebedingt ausgestiegen, da die Klimaanlage im Büro aus war :( Der Server fuhr aber laut Logs selbst herunter, ließ sich am Montag aber nicht mehr starten. Zugriff über eine Boot-Cd war möglich. Blöderweise hab ich mir die Datenbanken nicht auf USB-Platte gezogen, da am 10.07.10 nachts ne Datensicherung lief. Diese läßt sich aber nicht mehr aufrufen, weil die DR-Datei von BackupExec nicht erstellt wurde.

Die Daten des Intranet werden in einer Inhaltsdatenbank gespeichert, die auf SQL Express 2005 läuft (also wie die Wawi). Diese Datenbank konnte ich aus der Datensicherung ziehen, aber leider OHNE die Logdatei ".LDF". Die Datenbank scheint aber in Ordnung zu sein. Zumindest bringt mir das Tool "Sharepoint Recovery" keine Fehler.

Ich hab nun auf dem SQL eine Datenbank mit gleicher Größe und gleichem Namen erstellt, SQL-Instanz beendet, ShareWebDb.mdf gegen ShareWebDb.mdf aus Datensicherung getauscht und Instanz wieder gestartet. Datenbank wird nun logischerweise als "suspect" gemeldet und ausgehängt. Und ab dem Punkt weiss ich nicht weiter....

Ich hab alles mögliche versucht, z.B. über ne Abfrage mit CCDB CHECKDB repair_allow_data_loss, aber da hapert es bei mir dann eben an den fachlichen Kenntnissen. Die DB ist ca. 50 MB groß, also eher ein "Schmalhans". Es macht auch nichts wenn die Benutzerrechte und Zeitinfos dabei verloren gehen. Die sind nicht so wichtig.

Weiß hier jemand Rat???? Evtl. einer der SQL-Professoren hier :) ?

Wenn ich die Datenbank wieder sauber einhängen kann, ist der Rest kein Problem mehr. Das ist dann nur noch ein bisschen klicken im DNS, IIS und in der Sharepoint-Admin.

Falls der Beitrag hier stört, dann bitte möge ein Admin ins richtige Fach verschieben. Ich dachte eben, das das Problem auch auf die Wawi-Datenbank übertragbar ist.

Vielen Dank und Gruß
Arno aus Stuttgart
 

knuddel256

Aktives Mitglied
13. Juli 2009
19
0
AW: SQL-Datenbank retten? (Nicht aus WaWi)

Hallo Schlitzohri,

vielen Dank für die Antwort. Hier die Ausgabe:

The suspect flag on the database "ShareWebDb" is already reset.
DBCC results for 'ShareWebDb'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results for 'sys.sysrowsetcolumns'.
There are 2682 rows in 22 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 315 rows in 4 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 360 rows in 8 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 2682 rows in 21 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 315 rows in 4 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 360 rows in 2 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 15 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 124 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 1091 rows in 20 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 8327 rows in 196 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 3 rows in 1 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 0 rows in 0 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 30 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 731 rows in 15 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 1443 rows in 11 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 1669 rows in 483 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 15 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 137 rows in 1 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 14692 rows in 146 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 91 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 93 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 97 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 17 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 1014 rows in 47 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 0 rows in 0 pages for object "sys.sysbinsubobjs".
DBCC results for 'Deps'.
There are 2 rows in 1 pages for object "Deps".
DBCC results for 'NameValuePair_German_PhoneBook_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_German_PhoneBook_CI_AS".
DBCC results for 'GroupMembership'.
There are 14 rows in 1 pages for object "GroupMembership".
DBCC results for 'NameValuePair_Greek_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Greek_CI_AS".
DBCC results for 'AllDocs'.
There are 1302 rows in 76 pages for object "AllDocs".
DBCC results for 'Roles'.
There are 5 rows in 1 pages for object "Roles".
DBCC results for 'NameValuePair_Hebrew_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Hebrew_CI_AS".
DBCC results for 'SiteDeletion'.
There are 0 rows in 0 pages for object "SiteDeletion".
DBCC results for 'NameValuePair_Hindi_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Hindi_CI_AS".
DBCC results for 'RoleAssignment'.
There are 55 rows in 1 pages for object "RoleAssignment".
DBCC results for 'NameValuePair_Hungarian_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Hungarian_CI_AS".
DBCC results for 'NameValuePair_Hungarian_Technical_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Hungarian_Technical_CI_AS".
DBCC results for 'NameValuePair_Icelandic_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Icelandic_CI_AS".
DBCC results for 'NameValuePair_Japanese_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Japanese_CI_AS".
DBCC results for 'NameValuePair_Japanese_Unicode_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Japanese_Unicode_CI_AS".
DBCC results for 'AllDocStreams'.
There are 181 rows in 3 pages for object "AllDocStreams".
DBCC results for 'NameValuePair_Korean_Wansung_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Korean_Wansung_CI_AS".
DBCC results for 'NameValuePair_Korean_Wansung_Unicode_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Korean_Wansung_Unicode_CI_AS".
DBCC results for 'NameValuePair_Latin1_General_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Latin1_General_CI_AS".
DBCC results for 'NameValuePair_Latvian_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Latvian_CI_AS".
DBCC results for 'AllDocVersions'.
There are 2 rows in 1 pages for object "AllDocVersions".
DBCC results for 'NameValuePair_Lithuanian_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Lithuanian_CI_AS".
DBCC results for 'NameValuePair_Lithuanian_Classic_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Lithuanian_Classic_CI_AS".
DBCC results for 'AllLinks'.
There are 374 rows in 13 pages for object "AllLinks".
DBCC results for 'NameValuePair_Traditional_Spanish_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Traditional_Spanish_CI_AS".
DBCC results for 'NameValuePair_Modern_Spanish_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Modern_Spanish_CI_AS".
DBCC results for 'NameValuePair_Polish_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Polish_CI_AS".
DBCC results for 'NavNodes'.
There are 45 rows in 1 pages for object "NavNodes".
DBCC results for 'RecycleBin'.
There are 25 rows in 2 pages for object "RecycleBin".
DBCC results for 'NameValuePair_Romanian_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Romanian_CI_AS".
DBCC results for 'Sites'.
There are 1 rows in 1 pages for object "Sites".
DBCC results for 'NameValuePair_Slovak_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Slovak_CI_AS".
DBCC results for 'NameValuePair_Slovenian_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Slovenian_CI_AS".
DBCC results for 'NameValuePair_Thai_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Thai_CI_AS".
DBCC results for 'NameValuePair_Turkish_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Turkish_CI_AS".
DBCC results for 'NameValuePair_Ukrainian_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Ukrainian_CI_AS".
DBCC results for 'NameValuePair_Vietnamese_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Vietnamese_CI_AS".
DBCC results for 'WebParts'.
There are 242 rows in 8 pages for object "WebParts".
DBCC results for 'SiteVersions'.
There are 2 rows in 1 pages for object "SiteVersions".
DBCC results for 'Webs'.
There are 2 rows in 2 pages for object "Webs".
DBCC results for 'WebPartLists'.
There are 290 rows in 5 pages for object "WebPartLists".
DBCC results for 'Features'.
There are 48 rows in 1 pages for object "Features".
DBCC results for 'EventBatches'.
There are 1 rows in 1 pages for object "EventBatches".
DBCC results for 'EventCache'.
There are 93 rows in 5 pages for object "EventCache".
DBCC results for 'EventLog'.
There are 81 rows in 3 pages for object "EventLog".
DBCC results for 'EventSubsMatches'.
There are 0 rows in 0 pages for object "EventSubsMatches".
DBCC results for 'ImmedSubscriptions'.
There are 0 rows in 0 pages for object "ImmedSubscriptions".
DBCC results for 'Categories'.
There are 0 rows in 0 pages for object "Categories".
DBCC results for 'WebCat'.
There are 24 rows in 1 pages for object "WebCat".
DBCC results for 'AllLists'.
There are 41 rows in 4 pages for object "AllLists".
DBCC results for 'SchedSubscriptions'.
There are 0 rows in 0 pages for object "SchedSubscriptions".
DBCC results for 'Personalization'.
There are 0 rows in 0 pages for object "Personalization".
DBCC results for 'WelcomeNames'.
There are 2 rows in 1 pages for object "WelcomeNames".
DBCC results for 'DatabaseInformation'.
There are 2 rows in 1 pages for object "DatabaseInformation".
DBCC results for 'TimerLock'.
There are 1 rows in 1 pages for object "TimerLock".
DBCC results for 'AllUserData'.
There are 807 rows in 86 pages for object "AllUserData".
DBCC results for 'DiskWarningDate'.
There are 1 rows in 1 pages for object "DiskWarningDate".
DBCC results for ' Workflow'.
There are 0 rows in 0 pages for object "Workflow".
DBCC results for 'WorkflowAssociation'.
There are 0 rows in 0 pages for object "WorkflowAssociation".
DBCC results for 'ScheduledWorkItems'.
There are 0 rows in 0 pages for object "ScheduledWorkItems".
DBCC results for 'ComMd'.
There are 0 rows in 0 pages for object "ComMd".
DBCC results for 'HT_Settings'.
There are 5 rows in 1 pages for object "HT_Settings".
DBCC results for 'EventReceivers'.
There are 0 rows in 0 pages for object "EventReceivers".
DBCC results for 'HT_Cache'.
There are 0 rows in 0 pages for object "HT_Cache".
DBCC results for 'NameValuePair'.
There are 0 rows in 0 pages for object "NameValuePair".
DBCC results for 'ContentTypes'.
There are 348 rows in 4 pages for object "ContentTypes".
DBCC results for 'NameValuePair_Albanian_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Albanian_CI_AS".
DBCC results for 'NameValuePair_Arabic_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Arabic_CI_AS".
DBCC results for 'AuditData'.
There are 28 rows in 1 pages for object "AuditData".
DBCC results for 'SiteQuota'.
There are 0 rows in 0 pages for object "SiteQuota".
DBCC results for 'NameValuePair_Chinese_PRC_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Chinese_PRC_CI_AS".
DBCC results for 'ContentTypeUsage'.
There are 852 rows in 11 pages for object "ContentTypeUsage".
DBCC results for 'NameValuePair_Chinese_PRC_Stroke_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Chinese_PRC_Stroke_CI_AS".
DBCC results for 'NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS".
DBCC results for 'BuildDependencies'.
There are 124 rows in 4 pages for object "BuildDependencies".
DBCC results for 'Image0x'.
There are 1 rows in 1 pages for object "Image0x".
DBCC results for 'NameValuePair_Chinese_Taiwan_Stroke_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Chinese_Taiwan_Stroke_CI_AS".
DBCC results for 'CollationNames'.
There are 39 rows in 1 pages for object "CollationNames".
DBCC results for 'AllUserDataJunctions'.
There are 0 rows in 0 pages for object "AllUserDataJunctions".
DBCC results for 'NameValuePair_Croatian_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Croatian_CI_AS".
DBCC results for 'NameValuePair_Cyrillic_General_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Cyrillic_General_CI_AS".
DBCC results for 'NameValuePair_Czech_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Czech_CI_AS".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'UserInfo'.
There are 15 rows in 1 pages for object "UserInfo".
DBCC results for 'NameValuePair_Danish_Norwegian_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Danish_Norwegian_CI_AS".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'NameValuePair_Estonian_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Estonian_CI_AS".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'WebMembers'.
There are 20 rows in 1 pages for object "WebMembers".
DBCC results for 'NameValuePair_Finnish_Swedish_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Finnish_Swedish_CI_AS".
DBCC results for 'Versions'.
There are 4 rows in 1 pages for object "Versions".
DBCC results for 'Perms'.
There are 26 rows in 1 pages for object "Perms".
DBCC results for 'NameValuePair_French_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_French_CI_AS".
DBCC results for 'NameValuePair_Georgian_Modern_Sort_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Georgian_Modern_Sort_CI_AS".
DBCC results for 'Groups'.
There are 6 rows in 1 pages for object "Groups".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'ShareWebDb'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Warning: The log for database 'ShareWebDb' has been rebuilt. Transactional consistency has been lost. The RESTORE chain was broken, and the server no longer has context on the previous log files, so you will need to know what they were. You should run DBCC CHECKDB to validate physical consistency. The database has been put in dbo-only mode. When you are ready to make the database available for use, you will need to reset database options and delete any extra log files.
Meldung 926, Ebene 14, Status 1, Zeile 5
Database 'ShareWebDb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
DBCC results for 'ShareWebDb'.
CHECKDB found 0 allocation errors and 0 consistency errors in database 'ShareWebDb'.

Ich hab wie beschrieben ne neue DB erstellt, Instanz beendet, MDF-Datei über Explorer getauscht, LDF aus neu erstellter DB aber im Verzeichnis belassen, Instant gestartet und Abfrage ausgeführt. Im SQL Server Management wird die DB nach wie vor als "suspect" geführt. Hilft das SQL-ErrorLog weiter?

Gruß Arno
 
Ähnliche Themen
Titel Forum Antworten Datum
Neu Umzug SQL Datenbank auf neuen Server User helfen Usern - Fragen zu JTL-Wawi 2
Kundenstammdaten - "Eigenes Feld" in SQL auslesen JTL-Wawi 1.9 2
Aktuelles Update 1.11.7: Anmeldedialog merkt sich den letzten User immer noch nicht & falsche Warnung für angeblich fehlendes SQL Server Update JTL-Wawi 1.11 3
Neu Frage zu SQL Statement - Kunden-Kommentar aus Auftrag auf Pickliste User helfen Usern - Fragen zu JTL-Wawi 1
Neu Bestellungen werden verzögert oder nicht gepullt – Ursache: Zeitzonen-Filter im SQL des WooCommerce-Connectors WooCommerce-Connector 0
Neu SQL Worker.tStatus - Bedeutung von nStatus? JTL Ameise - Eigene Exporte 2
Neu Suche Servicepartner für SQL-Abfrage Dienstleistung, Jobs und Ähnliches 2
Neu askJan | Neuer KI-Assistent für JTL-Wawi - schnelle, effiziente und transparente KI-Datenanalyse - ohne SQL! Dienstleistung, Jobs und Ähnliches 41
Neu JTL-Wawi 1.11.5: Sequenzieller Kundenexport mit Workflow und SQL-Queue Schnittstellen Import / Export 2
Probleme bei der Verbindung zur Datenbank JTL-Wawi 2.0 10
Tabelle tfirma in der Shop-Datenbank ist leer Einrichtung JTL-Shop5 3
Neu JTL POS - nach Gerätetausch - Standard-Datenbank hinterlegen Einrichtung / Updates von JTL-POS 1
Update von 1.11.6 auf 1.11.7: JTL Worker verbindet nicht mehr mit Datenbank (WaWi schon) JTL-Wawi 1.11 1
Neu In welcher Datenbank-Tabelle sind Wertelisten und deren IDS von Eigenen Felder gespeichert? User helfen Usern - Fragen zu JTL-Wawi 8
Datenbank von Inaktiven Artikeln bereinigen JTL-Wawi 1.11 2
Neu Alternative zu https://wawi-db.jtl-software.de/ - Wawi-Diff zur Darstellung von Datenbank-Änderungen User helfen Usern - Fragen zu JTL-Wawi 6
Datenbank lässt sich nach Serverumzug nicht wiederherstellen JTL-Wawi 1.11 1

Ähnliche Themen