Is this for alwayson failover cluster or alwayson availability groups?

CREATE TRIGGER reminder2

ON Sales.Customer

AFTER INSERT, UPDATE, DELETE

AS

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'AdventureWorks2012 Administrator',

...

Set the filegroup to read-only?

Hopefully there's a lastBuildDate (if old lastBuildDate = new lastBuildDate, skip the whole feed) and a <item> pubDate (only process new pubDate's), but according to RSS 2.0 SPECIFICATION the dates...

How big is this system going to get? Are you going to run into scale-up issues eventually? If you know things are going to get huge, it's certainly...

n.heyen (3/2/2016)

---

I had posted a similar question last week but have more definition.

What the development team is asking for is to 'refresh' data from Prod into Test. Not a backup/restore...

Can you configure the third party app to point to the "SQL Server Network Name"?

is this helpful?

http://stackoverflow.com/questions/12786654/does-not-support-the-required-transaction-interface

The "physical_name" of the backup can be found in: backupfile

I've seen others go that route with clusters, local SSD tempdb storage. It's a relatively new feature for that reason.

Red-Gate +1

You may be interested in looking at these cluster level configs:

https://technet.microsoft.com/en-us/library/cc755151.aspx

Sure seems...

Just to add to the discussion...

If the OP has Enterprise edition, enables trace flag 2371 and auto update statistics asynchronously, does this become a non-issue?

Even though it's listed as a 2012 issue, it might be worth trying the workaround:

https://support.microsoft.com/en-us/kb/2689367