People are being very unhelpful asking questions rather than giving him the answer.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
People are being very unhelpful asking questions rather than giving him the answer.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
I thought we gave him good answers:
Gail: "...cannot recover past that last full backup that you have."
I should also mention that, up until the point he said about the deletion of the log, I was hopeful that it was recoverable. Had the log not been deleted (and the recovery model not switched to simple anywhere in the interval), that would have been recoverable right up to point of failure.
People are being very unhelpful asking questions rather than giving him the answer.
I hope you meant that as a joke.
-- Gail Shaw SQL Server MVP
er - what's the other option :).
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
I've had people tell me off for asking 'useless' questions rather than helping out, and they were being serious. One time it came with a 'if you don't know how to fix this, you shouldn't be wasting the OP's time with useless posts'
I think that was the OPs pomt of view - apart from the useless bit.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.