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.

Any way to use old data devices as is?

2 posts in ,  Windows NT Administration Last posting was on 2000-07-06 04:37:44.0Z
Eric T. J. Hogue Posted on 2000-07-05 17:55:12.0Z
From: "Eric T. J. Hogue" <Eric.Hogue@wpafb.af.mil>
Subject: Any way to use old data devices as is?
Date: Wed, 5 Jul 2000 13:55:12 -0400
Lines: 16
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: <WrMm9tq5$GA.203@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.administration,sybase.public.sqlserver.nt
NNTP-Posting-Host: b7o.bips.wpafb.af.mil 198.97.67.107
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.administration:3377 sybase.public.sqlserver.nt:528
Article PK: 1065538

We are about to rebuild an NT 4 (SP 6) machine with a RAID 0+5? setting
(i.e., the data files are completely separate from the operating system
files). All of our databases were created on dedicated data and log devices
(i.e., each device was either a data device or a log device, but not both,
further each non-master device was attached to a single database).

I know the "disk reinit" command will allow us to reuse the devices. Is
there a command/method that will allow us to use them a pre-created database
files, along the lines of "create DBS on DBSdata.dat maintain structure"?
If not, we are faced with the task of re-creating some 20+GB devices, and
then load in not-as-recent-as-desired data (this is a development system, so
the back-ups were not as frequent).

Eric


Anthony Mandic Posted on 2000-07-06 04:37:44.0Z
Message-ID: <39640D18.16171694@lumina.com.au>
Date: Thu, 06 Jul 2000 14:37:44 +1000
From: Anthony Mandic <am@lumina.com.au>
Organization: ... luminous thru all these years ...
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Any way to use old data devices as is?
References: <WrMm9tq5$GA.203@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.administration,sybase.public.sqlserver.nt
Lines: 33
NNTP-Posting-Host: 210.9.51.46
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.administration:3376 sybase.public.sqlserver.nt:527
Article PK: 1065537


"Eric T. J. Hogue" wrote:
>
> We are about to rebuild an NT 4 (SP 6) machine with a RAID 0+5? setting
> (i.e., the data files are completely separate from the operating system
> files). All of our databases were created on dedicated data and log devices
> (i.e., each device was either a data device or a log device, but not both,
> further each non-master device was attached to a single database).
>
> I know the "disk reinit" command will allow us to reuse the devices. Is
> there a command/method that will allow us to use them a pre-created database
> files, along the lines of "create DBS on DBSdata.dat maintain structure"?
> If not, we are faced with the task of re-creating some 20+GB devices, and
> then load in not-as-recent-as-desired data (this is a development system, so
> the back-ups were not as frequent).

Creating a device doesn't take too long. You can recreate the dbs
with the 'for load' option and then load from backup, but you should
have dumped more recently. But if you master device is intact on its
device (as are all the others) and the drive lettering scheme is the
same (or however NT does it) then you should be able to point your
run script back at the same master device and everything should come
up.

-am