Right. Not only not meaningful, but messy, at best. Include the logic pointed out in the article I linked (or any other you found on this topic), so the backups...

If you created the same scheduled job on both replicas, and are not doing the right backup config, you might be creating a mess with your backup chain.

The fact that...

Interesting insight into the research process to find out what the root cause might be.

I am a little confused though about your comment:

Since the full backup job of both replicas...

Thanks Bevan! Seems that order clause fixed the issue. Look like the output is now correct.

Same thing here. I used the code attached to the article, and the result set has almost all initial values replaced with other values and the results is not valid...

Very interesting Bevan! Thanks for article. Can't wait for next part!

To tripple-check, I just tested in on a 75K character long SP and it printed out just fine. If you look at the code, it dynamically makes sure a CR+LF...

David, I believe the code I posted does not have that problem. I routinely use it when I need to recover some code that was updated.

Great article. We have been using DDL Loging for quite some time, with different iterations of T-SQL scripts.

And, there is a way to circumvent the PRINT limitation on length and...

We have deployed several VM clusters with SQL 2012 on VMWare, and there's some caveats to it. If you want to use shared storage it basically breaks, at least for...

Brent Ozar (1/15/2013)

---

The log-bigger-than-database check is one of my favorite recent additions. I can't believe how often it comes up, and it's something I never would have thought to...

jeffreddy (1/10/2013)

---

SQLDBA360 (1/10/2013)

---

*prepairing to be shot down

I've never had any problems setting SA as the DB owner with the SA account disabled, its a practice I follow even when the...

ouch... and someone googling that will...

Have you thought about Replication?

TemDB will not automatically shrink back, but you need to take something bigger in consideration: how often will this happen? If it will be frequent, it would be best to...