Not that I want to say this script isn't great but...

Why the hell would you load this into a text file, then parse the text file?

When you could use...

Jim P. (8/31/2012)

---

The nearest I could find to it is the blog item that was cited in the article.

But if you look at the dates on the blog it was...

Jim P. (8/31/2012)

---

Do you have replication going?

This bug was...

Thanks Gail, please keep up the great knowledge transfer.

I agree with others, read what you (and Steve) write and you will be a great DBA.

Well it has helped me...

cfradenburg (8/16/2012)

---

Any chance the...

cfradenburg (8/16/2012)

---

Adam Seniuk (8/16/2012)

---

Also when installing I found it easier to install with default accounts then go back and reconfigure the services with the AD accounts, any one see issues...

BlackHawk-17 has it right, I cannot create accounts but I do need to keep track of them. Also I am in a government position so there is red tape when...

I like the idea but managing a service account for every server is a nightmare for my environments. We have upwards of 100 instances so that would mean 100 separate...

Thanks for the details but we have abandoned this idea as other solutions are better suited (currently) but SQL 2012 might be better.

Thanks for the update, I guess I just assumed some of that would be researched before purchasing. 😀

Also I can agree with some of the very cheap drives comment...

SSD's (Enterprise Level) have enough read and write cycles that you should not worry about them dieing out before the hardware becomes obsolete.

Here is what I have noticed, if...

Reply to Lynn:

Nope just log shipping is being applied to the secondary server.

So even after I did a full backup and restore with log backup and restore? Hrm... something is fishy.

I guess I am going to have to look at our backup...

Reply to MysteryJimbo

Break as in the LSN is now out of sync so it won't restore the log shipping on the secondary server.

Here is the error: Skipping log backup file...

Reply to SS999

SQL 2008 R2 Enterprise

Well what we are noticing is that log shipping will fail after a differental backup and then we have to do a backup and restore...