January 23, 2004 at 2:49 am
Please suggest me a way where in the log files in SQL SERVER are deleted automaticallty at the end of the day at certain time.
January 23, 2004 at 6:52 am
Do you really want to delete them or just shrink them back to as close to original size as possible?
January 23, 2004 at 6:55 am
If all you want is to shrink them try:
BACKUP LOG dbname WITH TRUNCATE_ONLY
DBCC SHRINKFILE(dbname_Log, truncateonly)
Hall of Fame
January 28, 2004 at 7:22 am
Be sure to do a full backup after the truncate_only. I'm wondering, what exactly are the ramifications of truncate_only? Is it only clearing unneeded transactions?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply