Hi,

You might want to check out this post:

http://www.sqlskills.com/blogs/paul/why-is-log_reuse_wait_desc-saying-log_backup-after-doing-a-log-backup/

Ness (4/26/2016)

---

Nice article although I think "Verify SQL backups" is misleading; there is nothing verifying the backups, just checking that they ran and completed. You would need to restore and...

Good idea to check on orphaned files!

You could also correlate the two tables by joining them, and simplify the script:

SELECT MF.physical_name, FL.Filepath

FROM #FileList FL

LEFT OUTER...

yech61813 (11/24/2015)

---

It is good. However, hard-coded WHILE (@no < 7)

There are times you need more than 7 log files, for example, SOX may require to retain a year data.

This parameter...

Update Nov 4:

Although the text in this article does not mention it, the scripts in the re-published article now support SQL 2012.

The (updated) scripts will also allow you...

Yes, I have an updated version...

The changed code,...

bdmelvil (4/10/2015)

---

So the edit to the SP worked great.

The edit to the PS script is giving an error now. I edited the section you specified like this (the bolded...

bdmelvil (4/9/2015)

---

I really like the idea of this script, and see value for it in my environment. Is there a suggestion you can make to alter the trigger of...

Thank you for a very useful article!

Small addition: make sure you choose the time specified in your FIRST 'restore log with stopat' command early enough, i.e. well before the...

Willem G (1/23/2015)

---

SQL Data...

SeaTiger (2/9/2015)

---

Yes i did. It does run as a success on the Job now but i dont get the table populated yet.

I get something like this on the log...

SeaTiger (2/3/2015)

---

Good article. I am looking to use this on my work environment as part of a solution to monitor growth.

I followed all the steps and the job runs...

Hi qh,

Good question! I...

Hommer (12/5/2014)

---

Hi,

I like the script but...

I like it as it replaced my broken ps which was fine with sql2008R2 but failed on sql2012. Also it runs flawlessly when my servers...