Silly Question

Is there any why to load a master database dump into another database?
Want to get some tables out of it.

We have rebuilt the server but are not loading the master.

Cheers

Mark



--- Posted via news://freenews.netfront.net/ - Complaints to news (AT) netfront (DOT) net ---

On 18-Oct-2011 02:22, Hello wrote:
A dump of the master database can only be loaded into the master
database, which will overwrite it. So you want to do this on a separate
server (i.e. copy your master device, and start it with a different
server name on a different port number).
In order to load the master database, you need to start that server with
the -m option.
Before you can load the dump, you will need to run sp_addserver to
establish the name of the backup server to use. If your sybsystemprocs
database was located on your master device, then you're fine, but if
nor, you will have to either recreaet sybsystemprocs on the master
device (and load the installmaster script) or manually update a row in
the sysservers table (details here:
http://infocenter.sybase.com/help/in...ag2/X62910.htm)

When you've done all that, perform a 'load database'. When loaded, the
server will automatically shut down. Reboot afterwards and your dump
should be loaded.

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob (AT) NO (DOT) SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------

On Oct 18, 12:44*am, Rob V
<r... (AT) DO (DOT) NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote:
Not entirely true. In 12.5.4 ESD 1 and above, dumps of the master
database can
be loaded into an Archive database. The docs don't seem to explicitly
say so,
but internal training has mentioned it. The feature is quite useful
for extracting
table contents from a dump without having to allocate all the
resources needed
for a full database load.

See the general documentation on the CREATE ARCHIVE DATABASE command
at
http://infocenter.sybase.com/help/to...s/CHDBEFJD.htm

Cheers,
-bret

On 18-Oct-2011 17:57, bret_halford (AT) msn (DOT) com wrote:
Thanks for pointing that out.

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob (AT) NO (DOT) SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------

Thanks for that

Worked like a dream.

Cheers

Mark
<bret_halford (AT) msn (DOT) com> wrote

On Oct 18, 12:44 am, Rob V
<r... (AT) DO (DOT) NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote:
Not entirely true. In 12.5.4 ESD 1 and above, dumps of the master
database can
be loaded into an Archive database. The docs don't seem to explicitly
say so,
but internal training has mentioned it. The feature is quite useful
for extracting
table contents from a dump without having to allocate all the
resources needed
for a full database load.

See the general documentation on the CREATE ARCHIVE DATABASE command
at
http://infocenter.sybase.com/help/to...s/CHDBEFJD.htm

Cheers,
-bret




--- Posted via news://freenews.netfront.net/ - Complaints to news (AT) netfront (DOT) net ---