Right now, but last night when no one user this database I can't shrink it

Transaction information for database 'DB_Replicated '.

Oldest active transaction:

SPID (server process ID):...

Thanks for helping me,

database is subscription database for transactional replication.

Why are you trying to shrink? I am running out of space

How much free space is in the log file? 25GB left.

one file have 100GB that...

I can't take a backup now, it is a production db, I have to run during night time.

last three month my job was working fine, but last night i got...

that the only message I have in log.

SQL Server Scheduled Job 'Database Full Backup.Subplan_1' (0xBDCFF8C5B2FAFA408DA0E59818DCEFCE) - Status: Failed - Invoked on: 2010-06-04 00:30:00 - Message: The job failed. The...

do you have any sample scrip to compress the active log when no one useing the database and do you have sample script to shrink the tran logbackup

I try to compress the log file but it is not copressing because database is in FULL mode

Also, I can change the @value = 30, -- 30 second latency threshold

on replication monitor, still didnot get the email when latency in >60scc

I never got warning other then 0, even on replication moritor say 60scc

also, why do you using Where warning = 2?

my data is always 0

Thanks, I change the schedule to "start automatically when SQl Server Agent start.

but never get the email even i change @query_result_width = 03. but when I force to run the...

Thanks, i did try that, but I am getting an email in different times, but these email say lateracy is 60.00 that I set, but when i check on replication...

Thanks for reply, can you please let me know how to do it?

Thanks for the reply, I have the shrink the database because we upgrade the application and lot of data add and deleted also when I recreate the index my log...

Thanks,

when I recreate an index, my Tran log backup also increase from 1 MB to 150 GB