Unable to shrink the log file

• Srini kolar

  SSC Enthusiast

  Points: 180

  More actions

  February 28, 2007 at 10:29 pm

  #95168

  I'm unable to shrink the log file of one of the database.

  here is the query which i'm executing

  use master

  go

  sp_configure 'allow', 1

  go

  reconfigure with override

  go

  begin tran

  update master..sysdatabases set category = 1 where name = 'F87901'

  commit tran

  use F87901

  go

  EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0,    @time = 0, @reset = 1

  --

  dump tran F87901 with truncate_only

  --

  use master

  go

  update sysdatabases set category = 0 where name = 'F87901'

  go

  sp_configure 'allow', 0

  go

  reconfigure with override

  go

  but i'm getting out put like

  DBCC execution completed. If DBCC printed error messages, contact your system administrator.

  Configuration option 'allow updates' changed from 1 to 1. Run the RECONFIGURE statement to install.

  (1 row(s) affected)

  Server: Msg 18752, Level 16, State 1, Procedure sp_repldone, Line 1

  Another log reader is replicating the database.

  The log file is growing huge. Could anyone please help me?

  Thanks

  Srini

   

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  March 1, 2007 at 11:29 am

  #692684

  If you are replicating, you can't shrink the subscriber database. Only the publication database can be shrunk and then the shrink is replicated to the subscriber(s).

  -SQLBill