I've had the Pink Panther theme tune in my head all...

cafescott (9/11/2014)

---

Based on your earlier comment I'm going to research Transactional Replication as it seems the best way to copy a production DB two or three times a day during...

Nothing to do with the BEGINS and ENDs...

Managing a 4TB database and

Really?

Backup/restore works fine when you need to refresh a dev instance once every few days (which is what that question asks). It'll work for once a day, providing the DB...

Have you fixed what caused the log to grow? If not, this is just going to happen again.

Shrinking the log isn't going to stop it growing again if it needs...

Transactional replication?

I'd open a case with CSS about this:

During undoing of a logged operation in database 'ABC', an error occurred at log record ID (7718257:21496:62). Typically, the specific failure is...

To be blunt. Don't.

That's formatting for display, not data retrieval (unless Address3 has no user, which is what your example implies).

If you want to display like that, look at...

I love Pluralsight. I've started downloading their courses and playing them (audio-only) via the car's sound system when driving to work...

That is 600 lines of code... When I do tuning for clients, that size of procedure would probably take me half a day to work through.

Can you do some investigation,...

No. Should just go read only. Though since running out of space in this case, for some reason, sent the DB into recovery, there's a chance that will happen again.

You...

Clear up some space on D (move other DB's logs or allocate more space) and wait.

What error messages are there in the error log? A full log should not send...

Database state is RECOVERING? (check sys.databases)

Check error logs. Insufficient space should not do that to a DB.

Please note: 5 year old thread.