I mean transaction logs should copy to another server through the wan.

If there is not a way to prevent growing logs up, I should convince them to specify more bandwidth.

Thanks...

Actually business owner want to transfer all transaction logs to somewhere else through the WAN.

Database size : 80 GB

Number of tables : 296

Log size after Update Statistics : 4 GB

with bulk logged recovery mode, I lost point in time recovery

I have a small re-index job ( re-indexing 6 tables ) but timing is different and transaction logging happens hourly.

Thanks All,

What I want is "sp_helpindex" idea.

NewBeeSQL's script is fantastic, just needs a small change in size of Index_keys column in temp table.

Regards

Thanks Gail,

As I said before, in database->tables-> indexes, I should check every index one by one

What I want, having all indexes and columns in a window

Adam,

That's the point "Its zeroed because sql assumes that as you have backed it up, it is no-longer needed"

Thanks for your time and sorry for my weakness in describing my...

I do full backup every night and transaction log backup every hour and store on tape.

When I do a shrink/truncate logfile and then a full backup, I lost my chain...

Adam,

Thanks for your quick response.

My database is in 'FULL' recovery mode and I know this command.

Sorry I think I couldn't explain what I want exactly. I don't want to do...

Hi Adam,

I mean something like B.

I want to shrink logfile as I always have 4 weeks logfile. Can I ?