Help. The OP keeps asking questions about HA that I can't answer. I know they doesn't understand the stuff they're finding on the internet, but at least (finally) they're trying...

So I've been a DBA for eleven years now. In the past three days, I have learned twelve new things I never knew (but should have known) about SQL Server.

This...

Open up SSMS. Navigate to Security -> Logins. It should be there.

Those are the server level logins. If it's...

Eirikur Eiriksson (7/9/2015)

---

Quick questions, what is the .Net version on the box? Can you install the latest .Net if not already there? It's just a hunch but have the latest...

Brandie Tarvin (7/9/2015)

---

EDIT: I am adding this link for my own future reference. I used this to fix the Upgrade Advisor. Unfortunately, it's not working on the Setup Files. I...

Alvin Ramard (7/9/2015)

---

Unfortunately, the version of SQL I had didn't come with an install option that would tell it to ignore everything and just install anyway.

I couldn't uninstall because...

Thanks, Alvin.

If...

If the OS needs reinstalling, I...

Let the head banging commence. Any thoughts on my issue here?

Okay, I think I've figured out part of the problem. The SQL Server 2012 Setup Files are still partially installed. There were two versions in the Programs and Features and...

BTW, you do know how to use annotations to document an SSIS package, right?

So your own process prevents you from using the full suite of SSIS tools to accomplish your task?

That seems a little excessive to me. But yes, if you can't use...

Assuming you've ensured that your test DB restore to production will never overwrite an active production db...

You can script this out into a job. It's just a simple T-SQL...

GilaMonster (7/9/2015)

---

Designing a backup strategy that meets the company's RPO, RTO and maintenance windows.

It's all well and good for you to say 'I...

So far as I know, cluster resources can be deleted and recreated without affecting the actual physical disks. As far as the drive letters go, they are based on OS...