Let's break this up so that it's easier to see. (note, my VB is exceedingly rusty, so check for obvious errors)

single quotes (') are SQL string delimitors. Double quotes (")...

Where are the backups been written to?

(Local drive, network drive, tape, DVD, flash drive, etc)

What's the error message? network error...

If all the strings in the table are going to be more or less the same length (within say 10 characters, depending on size) then char, otherwise varchar.

Things like ID...

Nazier.vdrheede (11/27/2008)

---

The log in this backup set terminates at LSN XXX, which is too early to apply to the database. A more recent log backup that includes LSN XXX can...

Can you edit your post to fix it please?

Run the updates and the inserts in that proc one by one until you find the one throwing...

It's a 2 byte overhead for storing the length (although that's not exactly what is stored on the pages)

There's no memory impact for expanding varchars, but it can cause page...

Then there's something wrong somewhere in the function.

Please can you post the table's definition (the one that's failing) as a create table, and the function's definition along with a couple...

Which of your backups are failing?

Where are the backups been written to?

What's the error message?

How long have the backups been failing for?

HanShi (11/27/2008)

---

When it is ON a lot of locking will occur and the performance falls down. We added a scheduled job to change the setting to ON just before...

Moral of the story: Store dates in datetime columns, not as varchar.

Any possibility of fixing the tables?

On this site, yes, frequently.

We reference Books Online and MSDN instead. 😀

If you have no primary keys (aside, why not?) then you cannot do transactional replication. You can use snapshot, which will copy the entire database over at scheduled intervals, but...

Happy normal working day to all the people in the rest of the world.

Any errors in the SQL error log?

Is this the first time that you've seen an IO error?

When you have a couple hours where the server won't be heavily used, please...

Not much point in contacting CSS. SQL 2000 is no longer supported. (unless your company has an extended support contract with MS that is)