June 1, 2004 at 12:40 pm
I know this is a SQL Server Forum and not a Sybase Forum.. but I am having a problem with a SYBASE Database which I need to resolve before I can tackle migrating the Data to SQL Server.
I have about a 4 year old Sybase Database on a UNIX box where the MASTER DEVICE is full !! (I have plenty of Disk Space on the Server itself). I have one 'survival' book on Sybase where it talks about how to initially size the Master Device because it states how "difficult" it is to expand it later. Does anyone know how to do this?? or perhaps offer some advice?
Much appreciated.
June 1, 2004 at 3:43 pm
Take a look in the Google Groups here http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&safe=active&q=sybase+%22master+device%22+%22DISK+RESIZE%22
June 2, 2004 at 9:12 am
You are lucky, I'm in both environement more than 10 years.
What you need to do.
1. Shutdown with nowait
2. set -T3608 in your server run file, this will recover your master DB only.
3. Start your Sybase ASE
4. isql in, and either create new device or expand on existing device (alter database master on master=2 ???)
5. checkpoint
6. shutdown Sybase ASE
7. remove -T flag, restart.
You ae back in business
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply