Curious to see the disconnect -- yep, there doesn't seem to be any way someone with that resume would have that much problem writing an INSERT/SELECT.

Grant Fritchey (4/13/2016)

---

I agree with Jeff, it depends.

However, let's say Staging is really Staging, a place to validate deployments prior to production. Then no. I wouldn't have backups at...

Phil Parkin (4/14/2016)

---

Steve Jones - SSC Editor (4/14/2016)

---

Well, apparently I don't write good questions to teach these people things.

Maybe some of you should write some questions to help people learn...

Are you installing the SQL as a standalone instance, or as a failover cluster secondary node? The error sounds like the latter, but you should be doing the former.

Right, so does that make the basic password more secure? SQL Auth is not what I would call the most secure way to authenticate, and I was curious if...

Hmm... does that mean that they more strongly encrypt the SQL 2014 password? What is different there?

Jurassic

I have never seen a better way of moving SQL Auth logins than sp_help_revlogin. I always go straight to that and it never fails.

Is there any chance that the third party EXE is asking for user input? The behavior you describe will happen if you use xp_cmdshell to run a task where...

Grant Fritchey (4/13/2016)

---

nhansen pcc (4/12/2016)

---

So, to kind of re-iterate a question from higher in the thread:

If I do just a log backup in a timed job, and then restore a...

Grove

There is no one answer to that question but "it depends". Does your app team need to be able to recover its testing to a point in time? ...

Never never never manage AGs from Failover Cluster Administrator. Only in SSMS should you manage them.

Availability groups have no inherent connection to failover clusters. The most common pattern I know of for installation is to do two standalone installs of SQL on two nodes....

Again this is normal. There is a separate SSMS Express install. SSMS is not installed with SQL Express.