Re: Truncate log file

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

From: lurc (lurchot_at_hotmail.com)
Date: 08/05/04 

Date: Thu, 5 Aug 2004 17:56:48 +0800

Hi Hari,

Thanks.

Under SQL Query Analyzer, I run following statement,
sp_attach_single_file_db 'backoff_0801', 'E:\data\backoff_data.mdf'

But get error messages like,
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'backoff_0801'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'd:\tmxdb\backoff_log.ldf'
may be incorrect. 

-- 
Best regards,
Lurc
"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:OvS3j5seEHA.2396@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> If it is a development environment you could just attach only the MDF
file.
> It seems client has not shrink the LDF file.
> How to attach the MDF file only.
>
> sp_attach_single_file_db 'dbname'   , 'physical_mdf_name_with_path'
>
> This command will build a new LDF file.
>
> Thanks
> Hari
> MCDBA
>
> "lurc" <lurchot@hotmail.com> wrote in message
> news:ul$RprseEHA.2352@TK2MSFTNGP09.phx.gbl...
> > Hi all,
> >
> > Get one sql server 2000 database from one of our clients for analysis,
the
> > size of mdf is 850MB, but ldf is 3.5GB, is there any way to truncate the
> log
> > file?
> >
> > --
> > Best regards,
> > Lurc
> >
> >
>
>

Relevant Pages

  • RE: MultiUser Issues with Access2002 - Errors 3343, Invalid SQL,21
    ... The only way I got everything to work was to make a new empty database BE ... I'd be worried that some of these problems are causing corruption in my BE. ... Usually receive one of three Error messages: ... When I run simultaneous sessions (multiuser test & checkout) I will get ...
    (microsoft.public.access.modulesdaovba)
  • RE: MultiUser Issues with Access2002 - Errors 3343, Invalid SQL,21
    ... The only way I got everything to work was to make a new empty database BE ... docmd.openreport, opening an ADO Recordset, looping through an ADO Recordset ... Usually receive one of three Error messages: ... When I run simultaneous sessions (multiuser test & checkout) I will get ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access 2002 unexpectedly quits and Catastrophic Failure messages
    ... Compact the database to get rid of this junk: ... Clear the Link Master Fields and Link Child Fields properties. ... unexpectedly quits with no error messages and the info that was being ...
    (comp.databases.ms-access)
  • RE: Relationships, forms and command buttons
    ... pragmatism will I end up regretting it: for example, will the database be ... likely to throw up error messages if I keep things simple in this way? ... relate only to subsets; eg. journalists. ... journalists and putting it into a separate tblJournalists in a one-to-one ...
    (microsoft.public.access.gettingstarted)
  • Re: Access module does not continue past the Filter Method
    ... I have only seen the problem of "no runtime error messages" in this database. ... Public Sub Apply_Tech_Filter ... Debug.Print "Past the Filter" ...
    (microsoft.public.access.modulesdaovba)