You might get better feedback if you post in one of the SQL subfolders instead of the Notification Services area.

Good Points.  We went through something similar a while back, trying to import Excel files with garbage in them. At first we tried fixing it in SQL, but then said...

We have 2 different types.  One application has varchar 19, the other is char 50.

In both cases they are encrypted and have non-numeric characters.

 For CR-LF removal, I do something like this:

update

My_Table

set

ColumnA = replace(replace(ColumnA...

There are a few other longstanding bugs on this forum that are annoying .....  oh well

"....I HATE IT when the system eats my message whilst I'm writing it!...."

You mean when you type a long post, and then it gets wiped out for no reason...

You might get better feedback if you post in one of the SQL subfolders instead of the Notification Services area.

You might get better feedback if you post in one of the SQL subfolders instead of the Notification Services area.

You might get better feedback if you post in one of the SQL subfolders instead of the Notification Services area.

We run many of our "non-critical" databases in SIMPLE mode, but our production databases are definately in FULL mode.  Every database has a full backup every day.  You should be...

And you should understand that any database in SIMPLE recovery mode can only be recovered back to the last full backup. So if you did a full backup on Sunday,...

Can you give any more detail ?  What part of replication is getting blocked ?  I would think it's snapshots contending for the same tables as users.  Perhaps you change...

"... even though the second database has smaller files it may have more logged activity to back up. Check this from the size of the .trn files produced by the...

Yes, it's safe to run.  SQL won't delete logs that have not been backed up (in FULL mode)

But, if you backup the t-log more frequently, it won't need to grow...

I don't think you can avoid the rollback (I may be wrong - it's been a while) ....  but as I recall, running those data pumps as jobs is SO MUCH faster you'll probably...