So how are you replicating Image Columns? The only Replication Model that allows you to Replicate the Image and Text/NText DataTypes is Merge Replication!

What Replication Model are you using?

SELECT REPLACE(ABC*******, '*', '')

Save the current counters and when the server restarts, begin the counters again. Now you will have a continuation, it just means the counters will be saved to a differnet...

What is the sql.log file? Where is it found?

How bout some thought into your question!

What do you mean by "File is not responding to backup, shrinkdb or shrinkfile"?

Tell us what actually happens when you attemt to execute one...

I agree with SQL Draggon!

Just becareful of 1 thing! Hence my question about which Replication Model are you using.

When you remove replication...

Have a look in BOL for Replication\Backup and Restore operations

You will find there lost of info on what to do for a Disaster Recovery!

SQL blks? Please explain?

The normal course of action here is to firstly detirmine what is happenning just before the system hangs! This is simple to find out what is...

Lauren,

Do what kknudson said. Reverse engineer!

I have been using VISIO to Design SQL Server Databases for 4.5 years now and would not leave...

Did the UPDATE on 7 million rows work?

If it didn't, did the transaction log run out of space? Also check the transaction log on the Distribution Databases.

Firstly, you need to implement the MERGE Replication Model!

Secondly, when you are createing the Publication, you will be given a chance to set filters! If you setup Merge Replication on...

What replication model have you implemented?

Use SQL Profiler!

With the information you have provided, do you expect anyone to assist you?

Just what exactly is the problem? Put some thought into your question!

Where do you see the left over...