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.

Backing Up Adaptive Server to a Tape Drive On Another NT 4.0 Server

4 posts in Windows NT Last posting was on 1998-02-05 12:53:10.0Z
Gene C Posted on 1998-02-03 15:24:58.0Z
From: "Gene C" <genec@catlimited.com>
Subject: Backing Up Adaptive Server to a Tape Drive On Another NT 4.0 Server
Date: Tue, 3 Feb 1998 11:24:58 -0400
Lines: 12
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-Mimeole: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <PdHp69KM9GA.300@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5249
Article PK: 1081328

I have been trying, with no luck, to backup an adaptive server database
running on an NT 4.0 server to another NT 4.0 Server that has a tape drive.
I see that this is possible in the online books. I would like to use Sybase
Central to create the backups.

Any help or tips on how to do this would be greatly appreciated.

Thanks,

Gene C.


John McVicker Posted on 1998-02-04 05:45:27.0Z
Message-ID: <34D80076.868FCFB8@sybase.com>
Date: Wed, 04 Feb 1998 00:45:27 -0500
From: John McVicker <mcvicker@sybase.com>
Reply-To: mcvicker@sybase.com
Organization: Sybase Professional Services
X-Mailer: Mozilla 4.04 [en] (Win95; U)
MIME-Version: 1.0
To: Gene C <genec@catlimited.com>
Subject: Re: Backing Up Adaptive Server to a Tape Drive On Another NT 4.0 Server
References: <PdHp69KM9GA.300@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 55
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5241
Article PK: 1081319

Gene,
You may need to setup a 2nd backup server on the other machine.
The Sybase manuals show networked backup scenarios where you
have SQL Server + Backup Server on Machine A, then the network,
then Machine B with a Backup Server and a tape drive (or disk location).

The backup command includes an "AT Backup Server name" addition to it.
So, you would setup a Backup Server only on the 2nd machine,
add it to the SQL.INI file of the first, add the Backup Server into the
SQL Server with the sp_addserver command and then use the
DUMP DATABASE (or TRAN) like so:

dump database dbname
to tape_name at backup_server_name

The local backup server (named SYB_BACKUP in master..sysservers)
is then instructed to look for the location of the 2nd backup server,
make connectivity to it and then push the dump across the network
through the remote backup server to the 2nd backup server location's
destination (tape drive). The primary backup server does the reading
of disks under the SQL Server, and the network packet transfer
of the disk blocks to the 2nd backup server which writes to the
tape drive (or disk location). This is also a good way to take
TRAN LOG dumps and put them safely on a 2nd machine in
case the primary machine's disks go bad just after the dump
occurs.

You can look at that on the Web in the Sybooks collections. Here's
the page for SQL Server 11:

http://sybooks.sybase.com/cgi-bin/nph-dynaweb/srg1100e/sqlref/31156

Gene C wrote:

> I have been trying, with no luck, to backup an adaptive server database
> running on an NT 4.0 server to another NT 4.0 Server that has a tape drive.
> I see that this is possible in the online books. I would like to use Sybase
> Central to create the backups.
>
> Any help or tips on how to do this would be greatly appreciated.
>
> Thanks,
>
> Gene C.

--
John McVicker
Principal Consultant, District Lead Architect
Sybase Professional Services
Pennsylvania/New Jersey District
301-896-1765
mcvicker@sybase.com, mcvicker@bellatlantic.net, JohnMcVicker@compuserve.com

http://www.sybase.com
http://www.powersoft.com
http://www.isug.com


Gene C Posted on 1998-02-05 12:53:10.0Z
From: "Gene C" <genec@catlimited.com>
References: <PdHp69KM9GA.300@forums.powersoft.com>
Subject: Re: Backing Up Adaptive Server to a Tape Drive On Another NT 4.0 Server
Date: Thu, 5 Feb 1998 08:53:10 -0400
Lines: 8
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-Mimeole: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <OhzMoyiM9GA.178@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5236
Article PK: 1081322

I was passing the name of the dump device instead of correctly passing the
physical name of the dump device on the remote server with the tape drive.

Thanks to everyone for your help.

Gene C


Mark A. Parsons Posted on 1998-02-04 00:12:27.0Z
Message-ID: <34D7B26B.792C@compuserve.com>
Date: Tue, 03 Feb 1998 19:12:27 -0500
From: "Mark A. Parsons" <Iron_Horse@compuserve.com>
Reply-To: Iron_Horse@compuserve.com
Organization: Iron Horse, Inc.
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: Re: Backing Up Adaptive Server to a Tape Drive On Another NT 4.0 Server
References: <PdHp69KM9GA.300@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 15
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5246
Article PK: 1081325


Gene C wrote:
>
> I have been trying, with no luck, to backup an adaptive server database
> running on an NT 4.0 server to another NT 4.0 Server that has a tape drive.
> I see that this is possible in the online books. I would like to use Sybase
> Central to create the backups.
>
> Any help or tips on how to do this would be greatly appreciated.
>
> Thanks,
>
> Gene C.

Are you getting any error/warning messages when you perform your dump
command? What does your dump command look like?
--

Mark Parsons
Iron Horse, Inc.
[Team Sybase]