ASE 12.5 - sybmigrate - master device is almost full - Help ?

[P***@gmail.com]

Hello

Using sybmigrate to replicate a database onto a backup platform.
After a number or failed attempts (Probably my own fault because I was
trying to use a device that did not have enough space) I ended up
using the master as the repository.

The master is now nearly full on the source, and target.
I dropped the mtpdb$%.dataabse as directed in the following link,
which made available Is some space.
http://manuals.sybase.com/onlinebooks/group-as/asg12501e/irnewfun/@Generic__BookTextView/26266;pt=26512

When I use DBArtisan to look at the "Database fragments" I see that
the majority of space is being consumed by a number of copies of
systemmigratedb.

How do I purge/drop these to free up space on my master device ?


Any help would be appreciated

Sincerely

Peter

[Luc Van der Veurst]

What is the output when you execute the following statements via isql/sqsh :

use master
go
sp_helpdb master
go
sp_spaceused
go

?

Luc.

Post by P***@gmail.com
Hello
Using sybmigrate to replicate a database onto a backup platform.
After a number or failed attempts (Probably my own fault because I was
trying to use a device that did not have enough space) I ended up
using the master as the repository.
The master is now nearly full on the source, and target.
I dropped the mtpdb$%.dataabse as directed in the following link,
which made available Is some space.
When I use DBArtisan to look at the "Database fragments" I see that
the majority of space is being consumed by a number of copies of
systemmigratedb.
How do I purge/drop these to free up space on my master device ?
Any help would be appreciated
Sincerely
Peter