Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Database recover

2 posts in Windows NT Last posting was on 2000-03-10 07:07:39.0Z
zhang tao Posted on 2000-03-09 10:58:09.0Z
Reply-To: "zhang tao" <ztao@iname.com>
From: "zhang tao" <ztao@iname.com>
Subject: Database recover
Date: Thu, 9 Mar 2000 18:58:09 +0800
Lines: 7
Organization: ferryman's studio
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Message-ID: <j3jhgdbi$GA.111@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 202.103.78.72
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2438
Article PK: 1089890

Hi
Because my windows nt system dead, I reinstalled my os system(windows
nt4.0),but how to reuse the data in sybase sql server.

ztao@iname.com


Gary Estridge Posted on 2000-03-10 07:07:39.0Z
From: "Gary Estridge" <aaaa@aaaa.com>
References: <j3jhgdbi$GA.111@forums.sybase.com>
Subject: Re: Database recover
Date: Fri, 10 Mar 2000 02:07:39 -0500
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <XBlaAAmi$GA.302@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 199.orlando-08-09rs.fl.dial-access.att.net 12.77.195.199
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2434
Article PK: 1089887

Since your on NT the first thing you need to do is to move the original
master.dat and the sybprocs.dat files out of the sybase/bin folder. Then do
a new install of the same version of the SQL server. Accept the default
sizes for the master and sybprocs devices. Once the install is finished,
copy the original two dat files over top and replace the new installed ones.
As long as the other dat files that existed on the original server are still
in existence and in the same directory structures that the server was used
to seeing them in, then your server should be at the same place it was when
your server died on you. You might have to deal with some corruption
depending on what caused your problem to begin with.

Gary Estridge
Sr. Consultant
Sybase Professional Services

"zhang tao" <ztao@iname.com> wrote in message
news:j3jhgdbi$GA.111@forums.sybase.com...
> Hi
> Because my windows nt system dead, I reinstalled my os system(windows
> nt4.0),but how to reuse the data in sybase sql server.
>
> ztao@iname.com
>
>