I've been using HVR to send our SQL Server data to Snowflake for many years (since before they were bought by FiveTran) and am very impressed with the product. I've...

Figured this out.. I was setting up log shipping to seed a new AG replica. As part of that, I removed the log backups from Ola's script and used the...

• This reply was modified 1 month, 3 weeks ago by  shaun.stuart.

While the storage itself is cheap, the network IO costs are not. When we looked into this, the IO costs made this non-viable, especially if you verify your backups, which...

Not sure the example for which table uses the most CPU is working. If you look at the output, none of the tables listed shows a CpuTime value. I get...

When you manually add databases to the AG (via backup / restore), you do it one database at a time. I'm planning on restoring one database and stopping there temporarily.

Just to follow up on this. I found out how this could happen. The BOL entry for UPDATE STATISTICS says:

We recommend against specifying 0 PERCENT or 0...

This will change the endpoint owner, but you may also run into the situation where the owner of the actual AG was no longer with the company. This query shows...

Bummer. Thanks to all three of you for thinking about this! If you all are stumped, I don't feel bad about not having a clue. Well, I kinda do, but...

Thanks for the research. There is definitely data in the table - over 9 million rows and they've been there for months, if not years. After posting this, I found...

I manage 120 SQL servers across our prod, dev, and QA environments. We are 100% virtualized.

Tushar Kanti (2/27/2014)

---

Hi Shaun,

I tried it out myself this morning to check if the restore entry goes in backupset table but could not succeed in that. I have been using...

If the backup history tables have not yet been cleared, there is an easier way to find out if the restored backup came from a different server that doesn't involve...

It does not handle mount points. I do not have any servers utilizing those in my environment, so I have nothing to test against. Sorry.

Have not tried it with C:...

thadeushuck - Define "better off."

1. That's your call. It depends on your environment. This is a monitoring routine that I run overnight during a period of little system activity....

Pradeept - That sounds like a Windows security setting issue. It sounds like Windows is configured to not allow execution of PowerShell scripts. Check with your network guys and see...