Then you cannot get the table back. I hope this was not production...

Thank you Perry, I also have MS involved and they could not get the DB switched over to NONE either. I will email results once I have them.

Well to make a bad story sound meh, I was pushed into AlwaysOn \ contain and it was the wrong thing to do, I tried to fight it but alas...

Steve,

??? on the second...

Steve Jones - SSC Editor (10/17/2013)

---

This is a complicated question. It's not easily answered.

TDE will encrypt the data files and backups. Without the password, people will not be able to...

encrypt the database and no one can see it. Do you stil want it in excel? SSRS cannot encrypt.

so what I have gathered so far;

1. stop sql agent (thanks I totally forgot)

2. RUn script as seen below;

USE (mydatabase)

GO

ALTER DATABASE (mydatabase)

SET SINGLE_USER;

GO

ALTER DATABASE (mydatabase) SET CONTAINMENT = NONE

GO

ALTER DATABASE...

so I would run this;

USE (mydatabase)

GO

ALTER DATABASE (mydatabase)

SET SINGLE_USER;

GO

ALTER DATABASE (mydatabase) SET CONTAINMENT = NONE

GO

ALTER DATABASE (mydatabase)

SET MULTI_USER;

GO

USE MASTER

GO

SP_CONFIGURE 'CONTAINED DATABSE AUTHENTICATION', 0;

yes you can. AlwaysOn can be used with a FCI 2012 as a DR plan. I found an article on this a few months ago.

http://www.sqlskills.com/blogs/joe/alwayson-architecture-guide-building-a-high-availability-and-disaster-recovery-solution-by-using-failover-cluster-instances-and-availability-groups/

Is this the log shipping you re-created yesterday because you deleted the agent job?

Let me break this down for you;

1. Backup DB on stand alone server.

2. Restore DB on Primary node (AlwaysOn)

3. Run the create script I get from running the SP_revlogin

4. Users...

MS does not support 3 Node Virtual machines thus mine is a 2 node...

If you accomplish this please share! 🙂

It has rolled, it works either way, it's more a preference not a best practice

matter of fact, your answer may be on here,,,

http://www.sqlservercentral.com/Forums/Topic1101492-146-1.aspx#bm1103005