6.5 Servercrash

Hello,
we have a NT4-Server with SQL 6.5 SP5 running.
The xx.DAT Database is already here.
Who can I read the Data in the DAT-File?
Who can I convert the DAT-File to a SQL2000
Here is the origin text in german:
Unser SQL 6.5 Server ist gecrasht.
Die SQL 6.5 Datenbank xxx.DAT habe ich noch.
Wie kann ich diese auf einem anderen 6.5 System wieder aktivieren.
Am besten jedoch wre eine Mglichkeit, dieses DAT-File gleich auf einem
SQL2000 Server einzubinden.
Wer kann mir helfen?
Alexander
fter a Harddisk-Crash> Who can I read the Data in the DAT-File?
SQL Server 6.5.

> Who can I convert the DAT-File to a SQL2000
You need to have a 6.5 server running and then you can upgrade using the SQL
Server 2000 upgrade
wizard, script and DTS or some other method.
So, you need to have a working 6.5 installation to get to the data. You can
then read about the
commands DISK REINIT and DISK REFIT. Hopefully they will work for you.
Unless, the files are actually backup files from the 6.5 server (performed w
ith the DUMP command).
If so, read about the LOAD command.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
news:e180po$5s9$02$1@.news.t-online.com...
> Hello,
> we have a NT4-Server with SQL 6.5 SP5 running.
> The xx.DAT Database is already here.
> Who can I read the Data in the DAT-File?
> Who can I convert the DAT-File to a SQL2000
> Here is the origin text in german:
> Unser SQL 6.5 Server ist gecrasht.
> Die SQL 6.5 Datenbank xxx.DAT habe ich noch.
> Wie kann ich diese auf einem anderen 6.5 System wieder aktivieren.
> Am besten jedoch wre eine Mglichkeit, dieses DAT-File gleich auf einem
> SQL2000 Server einzubinden.
> Wer kann mir helfen?
>
> Alexander
> fter a Harddisk-Crash
>|||Hi Tibor,
thank you for your answer.
with the command DISK REINIT , i had receive an error. The File have maybe a
mistake.
Is there any other way got get the data out of the DAT-File?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
im Newsbeitrag news:OnOzi5vWGHA.1220@.TK2MSFTNGP02.phx.gbl...
> SQL Server 6.5.
>
> You need to have a 6.5 server running and then you can upgrade using the
> SQL Server 2000 upgrade wizard, script and DTS or some other method.
> So, you need to have a working 6.5 installation to get to the data. You
> can then read about the commands DISK REINIT and DISK REFIT. Hopefully
> they will work for you.
> Unless, the files are actually backup files from the 6.5 server (performed
> with the DUMP command). If so, read about the LOAD command.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
> news:e180po$5s9$02$1@.news.t-online.com...
>|||Hi
It is not clear if you have SQL Server 6.5 running or not! There are quite a
few differences between SQL Server 6.5 and SQL 2000, therefore there is not
the same automatic conversion options that you would have with SQL 7.0. If
SQL Server 6.5 is running, you can use DTS to transfer the information,
although I would take the script and bcp route.
John
"Alexander Koch" wrote:

> Hi Tibor,
> thank you for your answer.
> with the command DISK REINIT , i had receive an error. The File have maybe
a
> mistake.
> Is there any other way got get the data out of the DAT-File?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
> im Newsbeitrag news:OnOzi5vWGHA.1220@.TK2MSFTNGP02.phx.gbl...
>
>|||How did you execute DISK INIT? On what version of SQL Server? What error mes
sage? This process is
not trivial, so you might want to hire a consultant who knows his/her way ar
ound 6.5 to do this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
news:e189kl$q8n$03$1@.news.t-online.com...
> Hi Tibor,
> thank you for your answer.
> with the command DISK REINIT , i had receive an error. The File have maybe
a mistake.
> Is there any other way got get the data out of the DAT-File?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
im Newsbeitrag
> news:OnOzi5vWGHA.1220@.TK2MSFTNGP02.phx.gbl...
>|||Hi Tibor,
my SQL 6.5 Server is still running.
I executed the command DISK REINIT successfully. But The answer from the
server was, that the Database had maybe an error.
Did you know a tool, that read a DAT-File outside of the SQL-Server?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
im Newsbeitrag news:ubYawi9WGHA.1480@.TK2MSFTNGP03.phx.gbl...
> How did you execute DISK INIT? On what version of SQL Server? What error
> message? This process is not trivial, so you might want to hire a
> consultant who knows his/her way around 6.5 to do this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
> news:e189kl$q8n$03$1@.news.t-online.com...
>|||> Did you know a tool, that read a DAT-File outside of the SQL-Server?
I haven't seen such tool.
Again, this process is not trivial, so you might want to hire a consultant w
ho knows his/her way
around 6.5 to do this. Or open a case with MS support. I assume that you hav
e read about the command
in Books Online, of course.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Alexander Koch" <Alexander.Koch@.mannuss.de> wrote in message
news:e1d2r3$50o$02$1@.news.t-online.com...
> Hi Tibor,
> my SQL 6.5 Server is still running.
> I executed the command DISK REINIT successfully. But The answer from the s
erver was, that the
> Database had maybe an error.
> Did you know a tool, that read a DAT-File outside of the SQL-Server?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
im Newsbeitrag
> news:ubYawi9WGHA.1480@.TK2MSFTNGP03.phx.gbl...
>