Wha?

Well, at least I have a purpose in life...

AppSup_dba (9/4/2014)

---

I concluded Rollback failure from these log entries.

Error log

During undoing of a logged operation in database '', an error occurred at log record ID (xx)

Database was shutdown due to...

What's a DCS service?

The transaction log is full due to replication.

If you have transactional replication configured, make sure the log reader is running.

http://www.sqlservercentral.com/articles/Transaction+Logs/72488/

To start with, don't use multi-statement table-valued functions. They're notorious performance problems, especially when joined to other tables. That's because of the lack of stats on the table variables.

Try converting...

LadyDardar (9/4/2014)

---

Yes we need point in time recovery. Before I switch to simple, I do a full backup, switch to simple, rebuild indexes, switch to full recovery, do another...

Probably recommended by someone who doesn't know what recovery models do...

Does your system require point-in-time recovery in the case...

Um....

SQL does not corrupt its own databases. Corruption is...

Every single data modification is applied to the secondary.

AppSup_dba (9/4/2014)

---

Error log:

4078 transactions rolled forward in database 'database' (9). This is an informational message only. No user action is required.

Recovery of database 'database' (9) is 4% complete (approximately 146199...

It shouldn't be, I did say that.

Is the mirroring failing over?

Are there any useful messages in the error log?

Is the log on the mirror side also filling up?

Are you sure...

You just need a large net. What's so difficult about that?

CheckTable isn't all that checkDB does. Try CheckAlloc and CheckCatalog.

Have you tried the restart that the message mentions?

I don't even know if it'll work though. Also may cause problems when you go to deploy scripts. SQL treats 'table doesn't exist' and 'permission denied' the same way. You...