Re: How do I shrink my logfile?

From: Joseph Geretz (jgeretz_at_nospam.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 15:54:55 -0400

Thanks. I see BACKUP LOG <database name> WITH TRUNCATE_ONLY.

Can this be run through the Enterprise Manager UI, or only through script?

Thanks,

Joe Geretz

"Eric Sabine" <mopar41@hyotyt_mail_nounderscores.com> wrote in message
news:%23BqHjLAcEHA.3460@TK2MSFTNGP10.phx.gbl...
> There are good links on this page.
> http://www.aspfaq.com/show.asp?id=2471
>
>
>
>
> Joseph Geretz wrote:
> > I set my recovery model to simple. I set my database option to
> > AutoShrink. I backed up my database. But the logfile is still 2.3
> > GB(!). How do I shrink this?
> >
> > Thanks!
> >
> > - Joe Geretz -
>
>

Relevant Pages

  • RE: Recreating a database???
    ... Unfortunately the script that Enterprise Manager produces doesn't always ... to build a database using the scripts you've created. ... record the build into a .SQL file and as the builder builds in the correct ...
    (microsoft.public.sqlserver.programming)
  • Re: defination in script
    ... "Roy" wrote in message ... > I am using Enterprise Manager and all tasks, Generate SQL Script. ... from one database to another via export/import data, ...
    (microsoft.public.sqlserver)
  • Re: Recreating database on production machine?
    ... If you want to recreate the database with a script, ... SQL Server MVP ... >I know that you can use the graphical tools in Enterprise Manager to create ...
    (microsoft.public.sqlserver.tools)
  • Re: Recreating database on production machine?
    ... If you want to recreate the database with a script, ... SQL Server MVP ... >I know that you can use the graphical tools in Enterprise Manager to create ...
    (microsoft.public.sqlserver.programming)
  • Re: How do you create a databse?
    ... See Create Database in BOL. ... Dont see how it could be any ... > I think that it may be time to use a script to create databases. ... Which one do you use a script or Enterprise Manager? ...
    (microsoft.public.sqlserver.server)