How to shrink the log file?

Question

How to shrink the log file?

salliven

SSCrazy

Points: 2644
More actions
July 14, 2012 at 5:43 am

#277858

Hello!
I have a database with 29 GB log file on the FULL recovery modell.
I want to shrink the log file, but I don't know it.
I make these:
1.)
a.) FULL Backup
b.) Log backup
c.) Shrink log file (DBCC SHRINKFIE(DBNAME, 10000))
This is not work.
-------------------
2.)
a.) Change database to SIMLE Recovery modell
b.) Checkpoint
c.) Shrink log file
This is not work.
How to I know shrink it?
Thanks!

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Please read through this - Managing Transaction Logs[/url] and this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

salliven SSCrazy Points: 2644 More actions · Answer 2

Thanks Gail!

The problem is the log_reuse_wait_desc is replication, but this database is not publisher and not subscriber database. Now, how to I shrinking the transaction log?

Thanks!

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Read the second article I linked.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Vikrant S Patil SSCrazy Points: 2294 More actions · Answer 4

The information from the following URL may provide some help.

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/34ab68ad-706d-43c4-8def-38c09e3bfc3b/

salliven SSCrazy Points: 2644 More actions · Answer 5

This command sloved my problem:

EXEC sp_removedbreplication

Thanks!