 Re: Shrink the Log file
If you never backup the log (bad idea, IMO, I always back the log once en hour), then set the db
to simple recovery mode. To shrink the file physically, read about DBCC SHRINKFILE.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Juan C Gonzalez" < jcmireles@intermexwiretransfer
s.com> wrote in message
news:144fb01c26e22$e6e9f170$3a
ef2ecf@TKMSFTNGXA09...
> How can i shrink the log file if i can't back it up
> because i don't have enough free space in the hard drive.
Report this post to a moderator
|
10-07-02 06:23 PM
