It could be worse. Like this one - developer background, now a senior DBA, depends on forum answers to do their job

Train wreck waiting to happen.

If you want some laughs,...

There's an option within the maint plans to log all output to a file. If you do that, what's the exact error that you get?

I'll help you if you can answer my questions please. Right now I don't know what you're trying to do or what errors you're getting.

Why are you trying to restore...

I started posting on this forum because I wanted to improve my own SQL skills, and trying to figure out other people's problems seemed like a good way to do...

Anything in the SQL error log from around the same time?

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?