Re: URGENT: SQL 6.5 Server Crash
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 09/14/04
- Next message: Tibor Karaszi: "Re: Truncate Log on Checkpoint option"
- Previous message: Jeff Williams: "Run a view and Export results as a CSV file"
- In reply to: Google Mike: "URGENT: SQL 6.5 Server Crash"
- Next in thread: Google Mike: "Re: URGENT: SQL 6.5 Server Crash"
- Reply: Google Mike: "Re: URGENT: SQL 6.5 Server Crash"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 14 Sep 2004 23:31:37 +0200
1. Let MS help you though this. This is not something that can be done over a newsgroup
conversation.
2. Meanwhile, we can try to assist you in sorting out a few things. Most important is a clear
message of exactly what backups you have.
Are these database backup done by SQL Server?
Or file backups performed by some Windows backup software?
If the later, were they performed while SQL Server was running?
Also, check out the error message in SQL Server's errorlog file for when you start SQL Server. Also
the Windows eventlog. Write down or copy the errors. These will be needed by MS when trying to
determine what exactly happened.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Google Mike" <googlemike@hotpop.com> wrote in message news:25d8d6a8.0409141309.4f7e4b8f@posting.google.com... > We're still on SQL 6.5 (SP5a) due to too many tie-ins to existing > Delphi 3 apps. We're migrating to a new system, but must maintain the > old. > > * Server crashed after too many locks. Found the problem was a backup > job was set to do an hourly full backup instead of an hourly > transaction backup. > > * Start SQL and it lasts for 30 seconds and EXE in memory abends with > no real definable error code during recovery process. > > * We have DAT files, although they might be corrupt. We have backed > them up to tape. > > * We have backups of the data, but not the schema for the data. When > someone told me that backups were being handled, I thought both were > being handled but now found out today that both were not. We have data > schema only from a year ago. > > Please could someone on this planet help me try to recover database > schema and stored procedures some how for our business databases, even > if briefly and in an unstable environment. Millions of dollars and my > job are at stake here. I think we might be looking in the direction of > something called DISK REFIT and DISK REINIT but am not certain how > these work -- just read about them in google groups. > > Now waiting on MS to call me back with suggestions. Our TAM said that > the engineers will help us on best effort, but that policy has expired > and they're making an exception just this once.
- Next message: Tibor Karaszi: "Re: Truncate Log on Checkpoint option"
- Previous message: Jeff Williams: "Run a view and Export results as a CSV file"
- In reply to: Google Mike: "URGENT: SQL 6.5 Server Crash"
- Next in thread: Google Mike: "Re: URGENT: SQL 6.5 Server Crash"
- Reply: Google Mike: "Re: URGENT: SQL 6.5 Server Crash"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
