Check the autogrowth value in case it's verry large.

Before you shrink the file look at the modified date, and see if you have a daily job,task... that has completed...

You can not Remove Log file Each database need to have 1 Data file (.mdf) and 1 log file (.ldf) other wise you can not have a database.

Before...

I know, he want to "Delete" the file, so he 1st need to remove it from the database used files.

Hi deleting the log file was a big mistake, with a 100Gb snapshot i would expect the log at the subsciber to be twice that (gut feeling).

If you are replicating...

you can only delete files that are not in used by the database. Shrink the file will not make any difference, you will not be able to delete the file....

My distribution Db is just over 3Gb, the distribution clean up is running fine every 10 min on server A.

I have attached part of the sp_Who2 you can clearly...

Hi ,

Replication allow you to have a different destination table name, column name, NUMBER OF COLUMNS... but you will need to do it by using TSQL not the GUI....

Hi, I have found a soft solution to the problem

I have:

- Created a Transactional Publication (the origianl was Snapshot) for the Table and Columns that where locked.

...

Your index only exists in your source Table it will not get propagated by the replication. when you initialise your subscription check that the Destination table get droped then recreated....

Thank you all,

Thanks gail for your answer.

No that youve pointed it out, I had (some long time ago) a log file that was capped is size and the transaction...

Gail

Are you sure this acctualy occur as my log file grew from ~500Mb to over 70Gb (in 3 h) and then another 4h later it had still not rolled...

So guys basicaly If your transaction log is as big as your disk allowed and the trasaction is not completed, there is not lot you can do as:

- you can't...

All my Dev and Staging databases are on different box than production databases.

the Sp is fine as long as it's run regulary.

My question is more theorical what would be...

Hi,

To Add a bit more information (let me know what you need),

The statememnt was a store procedure that delete a large number of data, it's working fine in production...