You don't really need to change the operating mode, just remove the witness. When the principal becomes disconnected, it will transition to asynchronous automatically and then back to synchronous when...

I'm in.

You may need to contact PSS to see if it's possible to get a hotfix for this.

Jeff Moden (7/8/2012)

---

On that point...

Jeff, are you sure that person was an MCM? After all, you already made that mistake once in this thread. What was the bad advice given by the MCM?

Edit: Gail...

george sibbald (6/29/2012)

---

the resource database only changes when you patch SQL server so you only need to make a copy of it then (flat file copy). So do this manually...

It is better to back it up and not need it than to need it and not have a backup. Live by those words and back it up every time.

Business Intelligence Edition is just an Edition of SQL Server. That doesn't mean that the HA features listed are applicable to SSAS or any other BI component. When it says...

Hit this earlier this week with SQL 2008 R2. Updated the Connect bug.

Contact PSS and let them know you are seeing this in SQL 2012 and request a hotfix.

It's only possible if the new domain can authenticate users to the old domain. Otherwise, you have to change the accounts (and you should anyway).

Granting dbo to a user in a database would not alter the login; therefore, just because the login was altered at that time doesn't mean that was when it was...

Try setting the NoRecovery (rstDb.NoRecovery) property to false before calling the SQLRestore method.

Did you add it to the scripts library?

http://www.sqlservercentral.com/Scripts/

Print this out and hang it on your wall: BACKUP ALL THE DATABASES

You can backup the resource database's files through a simple robocopy script. Tempdb is the only database that...