the times I have seen this it is due to the size of the errorlog, and is resolved by bouncing SQL or the box.

If it won't cycle a 10MB log...

no,no,no, no fees to join sqlservercentral, ever, it would ruin it.

People have a problem, they do a search, a post from this site pops up, and voila there is their...

microsoft must have read my post and decided to rush it out! 🙂

please don't TRIPLE post, choose one and delete the other two.

make that quadruple

If a file is recorded as 100GB in size within a .bak file then when restored it will be 100Gb in size, no way round that.

You could use SSIS (export...

without tuf file it cannot roll forward ready for next log, so I see no way round this without starting from a restore, sorry.

Any chance its on a tape backup...

GilaMonster (10/24/2008)

---

As far as I know, all backup logs (including the no_log) have to write into the tran log to indicate that a backup was done. I don't know if...

Lee,

no probs. Not quite written script, if you want it automated, you'll have to put that in a variable and exec @variable

have fun

george

I don't think you would be able to get that information from a backup as its not held in the database itself but in master..sysdatabases.

So perhaps you are stuck with...

Gail, the situation I am thinking of is when there is no drive space available anywhere and the log is so full even a truncate_only won't work, then the no_log...

its an indian language term, used as a unit of measurement. Means quite a big amount, cannot remember how much, barry might be right

1 lakh = quite a lot really

something is issuing either a backup log with truncate only or backup log with no_log against one of your databases. This means the log is being truncated without the contents...

backup failures are reported in the errorlog so that should tell you why it failed.

Also, deletes are not done untill all backups are completed, so if one fails, no deletes...

cheers. lets hope RSN means before the next CU.

Are you guys still running on SP2?

ahh, allocated up to, now it makes sense, set it to dynamic, may as well.