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.

moving a database server to server

2 posts in Windows NT Last posting was on 2000-06-05 15:05:19.0Z
gs2020 Posted on 2000-06-04 07:24:06.0Z
Message-ID: <393A0415.1F54C019@opera.iinet.net.au>
Date: Sun, 04 Jun 2000 15:24:06 +0800
From: gs2020 <gs2020@opera.iinet.net.au>
X-Mailer: Mozilla 4.7 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: moving a database server to server
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 12
NNTP-Posting-Host: reggae-01-131.nv.iinet.net.au 203.59.62.131
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2061
Article PK: 1089535

I have a database on one NT server (a) and need to move it to another
(b).
Is it a simple case of:
Dump database on server (a)
Move the file to the dump device on server (b)
Then on server (b) do a load database.
These machines are running nt 3.5 have finally been given the go ahead
to upgrade them to NT 4.
Thus need to move the database over to another machines whilst the
primary server has it's OS upgraded.

Thanks
Graeme
gs2020@opera.iinet.net.au


Peter Veilleux Posted on 2000-06-05 15:05:19.0Z
Message-ID: <393BC1AF.C4D09C10@nvestservices.com>
Date: Mon, 05 Jun 2000 11:05:19 -0400
From: Peter Veilleux <pveilleux@nvestservices.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: moving a database server to server
References: <393A0415.1F54C019@opera.iinet.net.au>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 31
NNTP-Posting-Host: nefclient124.mutualfunds.com 206.136.227.124
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2058
Article PK: 1089532

Graeme,

you can do exactly what you described. On server (b), assuming the
database is not already created, just make sure it is the same size and
recreated in the same order (the commands issued) as server (a). You can
look at the world-famous Tech Doc 1324 for how recreate the correct
fragments/segments. I would also create the database for load, speed
things up a bit. Pls note, if you create it for load, you need to use
"for load" on *all* your create/alter statements....

come to think of it, you may even be able to just use the backup server on
server (a) to load on server (b). Just make sure it has an entry in
sysservers (sp_addserver). That should work too....

HTH,
Peter

gs2020 wrote:

> I have a database on one NT server (a) and need to move it to another
> (b).
> Is it a simple case of:
> Dump database on server (a)
> Move the file to the dump device on server (b)
> Then on server (b) do a load database.
> These machines are running nt 3.5 have finally been given the go ahead
> to upgrade them to NT 4.
> Thus need to move the database over to another machines whilst the
> primary server has it's OS upgraded.
>
> Thanks
> Graeme
> gs2020@opera.iinet.net.au