Re: logfile verkleinern

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ralf Dietrich (du.sollst.mir.keinen.spam.schicken_at_t-online.de)
Date: 03/13/04 

Date: Sat, 13 Mar 2004 21:58:54 +0100

Hi Karl,
Karl Gunkel wrote:
> Hi
> Ich hab da eine Datenbank die mdf hat 1.280 kb, das logfile 388.544 kb
> kann man das logfile verkleinern? wie?
> danke für Tips
> Karl
Ja (siehe Elmar)
Aber: Vielleicht solltest Du mal über ein Backup nachdenken oder wenn nicht
nötig (oder nicht gewünscht) dann halt evtl. ALTER DATABASE <name> SET
RECOVERY SIMPLE
bzw. in den Datenbankeigenschaften ändern :-) 

-- 
CU Ralf
---------------------------
www.damisys.de
---------------------------

Relevant Pages

  • Re: Supply Database Setup
    ... I'm with Karl, you'll probably want to spend some more time researching ... "KARL DEWEY" wrote: ... reading before beginning your database. ... I imported it into a table that has the Inventory #, Description, Cost, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How to put database results into an array?
    ... > Hi Karl, thanks for the reply. ... > about lots of different images, including the filename. ... the 'Next' button takes you to the next image in the database. ... I thought that by dumping them in an array, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Page.DataBind()
    ... Karl Seguin wrote: ... > connection, getting the single value and closing the connection, then you'll ... > get a db hit every time you see getText. ... > measure this by debugging your code or profiling your database. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Storing variables with Random Files
    ... Karl E. Peterson wrote: ... Method chosen: Random File Access. ... database to me and that was familiar. ...
    (microsoft.public.vb.general.discussion)
  • RE: calculated field
    ... Thanks for your response, Karl. ... The patient discharge database I manage ... field "los" (length of patient stay in days). ... I successfully execute the query when configuring the formula ...
    (microsoft.public.access.queries)