The log segment in my Sql Server database has filled up...

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

jordanac Hall of Fame Points: 3653 More actions · Answer 1

Firstly backup your database and try

DBCC SHRINKFILE

('Databasename',TRUNCATEONLY)

Andy.

Dan_2003 SSC Enthusiast Points: 132 More actions · Answer 2

Thanks Andy for your suggest.

Can i make it in an SQL Query Analyzer screen?

Dan_2003 SSC Enthusiast Points: 132 More actions · Answer 3

SSC Enthusiast

Points: 132

May 25, 2004 at 8:29 am

...the DBCC Shrinkfile?

SpiceDBA SSC Veteran Points: 221 More actions · Answer 4

Hi Dan,

Again, first backup your database, then try this:

Use Master

GO

-- Truncating the transaction log

BACKUP LOG <Database Name>

WITH

TRUNCATE_ONLY

Use <Database Name>

GO

-- Shrink Physical File:

DBCC SHRINKFILE ('<Database Logical Filename>', TRUNCATEONLY)

SreenivasaRao Ponguru SSC Journeyman Points: 85 More actions · Answer 5

Do sequencywise you will get solution

First Take backup if possible

USE (Database Name Which Having Problem)

GO

CHECKPOINT

GO

SELECT * FROM SYSFILES /* NOTE DOWN THE LOG FILE NAME*/

GO

DBCC SHRIKFILE(LOGFILE NAME)

GO

jordanac Hall of Fame Points: 3653 More actions · Answer 6

Sorry about the typo.. I ment logfile not database.....

Andy.