Re: How do I shrink my logfile?
From: Sydney Lotterby (sydney_at_infosearch.com)
Date: 07/22/04
- Next message: Kenny: "find out how often is a table get updated/inserted"
- Previous message: Sydney Lotterby: "Re: How do I shrink my logfile?"
- In reply to: Narayana Vyas Kondreddi: "Re: How do I shrink my logfile?"
- Next in thread: Kalen Delaney: "Re: How do I shrink my logfile?"
- Reply: Kalen Delaney: "Re: How do I shrink my logfile?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 22 Jul 2004 12:22:05 -0500
I followed the instructions in the link but when I run DBCC
SHRINKFILE(mydb_log,2) it says "could not locate mydb_log in sysfiles. I
checked sysfiles and, true, it is not there.
What can I do?
"Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
news:%23pOUoKAcEHA.3988@tk2msftngp13.phx.gbl...
> See DBCC SHRINKFILE in SQL Server Books Online. Also see:
>
> INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;272318
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Joseph Geretz" <jgeretz@nospam.com> wrote in message
> news:ewNWyDAcEHA.1656@TK2MSFTNGP09.phx.gbl...
> 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 -
>
>
>
- Next message: Kenny: "find out how often is a table get updated/inserted"
- Previous message: Sydney Lotterby: "Re: How do I shrink my logfile?"
- In reply to: Narayana Vyas Kondreddi: "Re: How do I shrink my logfile?"
- Next in thread: Kalen Delaney: "Re: How do I shrink my logfile?"
- Reply: Kalen Delaney: "Re: How do I shrink my logfile?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
