Deleting a log file -- sql server clients

Woody Splawn
10/1/2003 10:22:27 AM

I've noticed that there is a delete option in the Transaction log tab of the
properties for a database. What happens when I press that button <big
grin>. Seriously, I have a small database (Simple Recovery) but the log
file is three times too big. If I select the delete Log file button I know
the file goes away. my question is, does it come back automatically with a
smaller size or is there something more to it than that? Do I need to
recreate it explicitely? If so, what is the syntax?

Sue Hoegemeier
10/1/2003 6:26:07 PM

If it's your only log file, when you press the button you
will get an error along the lines of "primary data file or
log file can't be deleted"
Just shrink the log file down to the appropriate size. Refer
to the following:
INF: Shrinking the Transaction Log in SQL Server 2000 with
DBCC SHRINKFILE
http://support.microsoft.com/?id=272318

-Sue

On Wed, 1 Oct 2003 10:22:27 -0700, "Woody Splawn"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clients

sql server clients : Deleting a log file