Re: Extending segments in syslogs

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/05/04


Date: Sat, 5 Jun 2004 08:30:24 +0200

Extend the size of the current device that you have your transaction log on, or create a new database device
for this storage. Then use ALTER DATABASE to add this newly defined storage to the database.

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"BV" <anonymous@discussions.microsoft.com> wrote in message news:1850e01c44a95$50228a80$a301280a@phx.gbl...
> how do you extend syslog segments?  error message that
> i've ran out of space in syslogs and i either need to
> dump the transaction log or extend the segment.  I am
> running Sql 6.5


Relevant Pages

  • Re: Disk Bottleneck Detected...
    ... Database Through ESM on the properties of the database. ... The transaction logs - Through ESM on the properties of the storage ... How do you change the locations of the transaction log drives, ...
    (microsoft.public.exchange.admin)
  • Extend exchange 2007 database partition
    ... We have our Exchange databases on fibre channel SAN attached storage. ... We have already needed to extend one of the database volumes by presenting ...
    (microsoft.public.exchange.misc)
  • Re: reiser4 plugins
    ... And have you ever heared of the problem of Wikipedia storage? ... reduced the database by 85%). ... Reiser4 won't provide anything but the storage part. ... What userland tools you use to acess this filesystem is upon your decission ...
    (Linux-Kernel)
  • Re: reiser4 plugins
    ... > an entire new storage array and this wasn't/isn't cheap. ... > following versions of an article; reduced the database by 85%). ... So a filesystem with intelligent ... Any "unnecessary double work" would squarely be within ReiserFS... ...
    (Linux-Kernel)
  • Re: The Zen nature of a Delphi database application
    ... results directly to UI controls, then write data from the controls to ... then write data back from the modified objects to the DB for storage? ... I load the whole contents of the database into my business objects, ... I have dreamt of the perfect OO database application framework ...
    (comp.lang.pascal.delphi.misc)