You're either a DBA, or not. DBA's need to have sysadmin role in the instance or they cannot do their job. How can they set instance level settings...

Fantastic, thanks!

Your fix worked for me (installing .net framework 3.5).

Cheers

Eric, I will give it a try. Thank you.

If this works for me, as well, MS should update their documentation as it doesn't state anywhere in their "setup" that...

Your direct question has already been answered, however the audit will probably turn up a couple of things:

If they stole the diff backup, why wouldn't the full backup be stolen...

Shelley Allen (9/24/2015)

---

I'm apologize for the continued questions. But first time handling a job like this.

It works on the Primary AG group. On the Secondary, when the job runs...

This is my 1st step in every job on all nodes of my AG servers. When the function returns "NO", I raise an error and "quit job with success"...

TheSQLGuru (8/27/2015)

---

Eric Mamet (8/27/2015)

---

I must admit I came across CDC before and it might be a viable option too.

I don't have any experience of it though...

Has it got a...

When used with SSIS, you would schedule a job to port the data over from the _CT tables, so I think it's less traffic than replication might have. I haven't...

I see there is already an approved answer selected so wanted to waste everyone's time anyway 😉

I don't see many suggestions for using Change Data Capture (CDC) in an SSIS...

Why not have the reports hit the secondary replication? The secondary could either by synchronous or async.

For the reports, use the paramenter "applicationintent=readonly" and that will send...

Why don't you just create an SSIS package and call the webservice (using the WebService Task) from the package? This will allow you to pass in the necessary credentials...

The commands are all in the SQL Server Books Online, at MSDN.

https://msdn.microsoft.com/en-us/library/ms130214(v=sql.110).aspx

Whether, or not, they're difficult to learn is really up to you, but a "functional" DBA would...

Try and stay away from the wizards and gui as much as you can while you are learning. Learn the TSQL commands and syntax for performing backup, restores, create...

SSMS

After you login, just download the Management Studio.

SQL Server 2014 Management Studio Express 32 Bit or 64

If you already downloaded/installed

SQL Server 2014 Express with Tools 64 Bit or 32

or

SQL...