Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 'Cannot shrink log file 2 (Claim_Log) because all logical log files are in use.'
- DBCC SHRINKFILE (N'Claim_log' , 0, TRUNCATEONLY)
- 'Executed as user: *. Cannot shrink log file 2 (Claim_Log) because all logical
- log files are in use. [SQLSTATE 01000] (Message 9008) DBCC execution completed.
- If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]
- (Message 2528). The step succeeded.'
- Execute SP_ReplicationDbOption {DBName},Publish,true,1
- GO
- Execute sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time = 0, @reset = 1
- GO
- DBCC ShrinkFile({LogFileName},0)
- GO
- Execute SP_ReplicationDbOption {DBName},Publish,false,1
- GO
Add Comment
Please, Sign In to add comment