I've verified that the system time on both are exactly in sync within one second or less. Also, there is no pausing of the jobs at an any time,...

yes, the result set from your posted query shows accurate information. It shows the same information the Log Shipping Monitor from Red-Gate shows.

The Red Gate Shipping Monitor is just a monitoring software to inform me that log shipping is working in all its facets.

I'm using the native Log Shipping in SQL Server.

Evil Kraig F (12/13/2010)

---

You might try ALTER DATABASE SINGLE_USER ROLLBACK IMMEDIATE.

This will force the database to a single_user mode (the one running the process) and rollback all transactions when it...

I was pretty sure this job just updated the dbm_monitor_data table in MSDB. This job isn't configured to report if there are issues, so you'd have to employ another...

I've been waiting for the process to finish for several hours now. When I first ran the kill command after seeing the SPID in rollback status, I got the...

Great link and info, but somewhat difficult to follow at certain points. It definitely needs proofreading as the punctuation is sub par 🙁

Strange, I used the URL editor and mine didn't make the link like yours is shown 🙁

Received an answer on another site, wanted to post in case someone else ran into this question.

That is a cool trick that I didn't think of, thank you!

I'll use this for the time being to make sure I have good data, but I'm still concerned that...

Alright, posted this in twitter (#sqlhelp), linkedIn, and some other places....no one has an answer 🙁

Thank you for your time Gail, I appreciate it!

GilaMonster (9/10/2014)

---

Steps:

1. Backup the TLOG

2. Change DB from Full to Simple

3. Change the initial size of the TLOG to something much smaller

4. Perform the log shrink

5. Change from Simple to...

GilaMonster (9/17/2008)

---

No impact other than that you will no longer be able to take log backup and hence will not be able to restore to a point-in-time after switching to...