MS SQL Server - 6.5 Servercrash

Author

6.5 Servercrash

Alexander Koch

2006-04-08, 7:23 am

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 wäre eine Möglichkeit, dieses DAT-File gleich auf einem
SQL2000 Server einzubinden.

Wer kann mir helfen?

Alexander
fter a Harddisk-Crash

Tibor Karaszi

2006-04-08, 7:23 am

> 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 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...
> 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 wäre eine Möglichkeit, dieses DAT-File gleich auf einem
> SQL2000 Server einzubinden.
>
> Wer kann mir helfen?
>
>
> Alexander
> fter a Harddisk-Crash
>

Alexander Koch

2006-04-08, 7:23 am

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@hotmai
l.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...
>

John Bell

2006-04-08, 1:23 pm

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@hotmai
l.nomail.com> schrieb
> im Newsbeitrag news:OnOzi5vWGHA.1220@TK2MSFTNGP02.phx.gbl...
>
>
>

Sponsored Links