|
|
Posted by Tom Moreau on 08/22/06 14:47
Hmm. If possible, do a full backup of master. Also stop and start SQL
Server.
You may have to do a rebuild of master. I'd stop SQL Server, copy the
devices on which master resides to a safe place and then rebuild master.
Extend the master device. Start SQL Server in single-user mode and then
restore the backup.
Hopefully, I've got it right. It's been a very long time since I last used
6.5...
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
<brian.j.parker@gmail.com> wrote in message
news:1156257305.897687.128200@p79g2000cwp.googlegroups.com...
Tom Moreau wrote:
> Have you also tried:
>
> DUMP TRAN master WITH TRUNCATE_ONLY
>
> Also, consider just creating a new device and extend the log onto it.
Thank you, Tom, for replying.
Using "DUMP TRAN master" with any combination of NO_LOG and/or TRUNCATE
ONLY gives me the error "Can't allocate space for object 'Syslogs' in
database 'master' because the 'logsegment' segment is full..."
Trying to create a new device in Enterprise Manager or by using "DISK
INIT" either hangs or returns the same error.
Very frustrating!... if I could just dump the log, it seems, I could
add plenty of space.
Navigation:
[Reply to this message]
|