I'm not sure if you need a DNS name for an AG group, especially if the AG group is going to potentially span multiple subnets. As for the question...

You have no permissions to use the database.

Is the guest user enabled in the MSDB database?

Are you certain you have the username typed in correctly?

Or if this is a windows login, is the login a member of any of the Active directory groups that has...

It depends.

Well, probably not. The fact that you do not want this new database, and one of the groups to not fail over seems to imply that the new...

For this procedure, no. Anyone who runs it would need to own the table (or the database), in order for no error to be returned. There does not...

You can replicate stored procedures, and views if you dedicate yourself to only ever issuing ALTER statements on them to introduce new versions. A lot of places will generate...

One thing to make sure of is that the weaker server (the 64 core machine) will be able to support the whole load. With a 20% difference in cores...

It's entirely likely that the service failed over. If the SAN (or the switch network supporting the SAN) was having problems, this could affect both servers at the same...

I believe you would need to license 12 cores with SA, but Enterprise edition. This assumes that the second node in the VMWare cluster is only used for failover....

Also, since this is part of the backup routine, you will want to take into consideration what going through with the backup will entail. Especially if that means you...

The only way (as far as I know) is to break the mirror, and recover the secondary copy of the database. They may have done it this way to...

I think this was answered on another site:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c99376d5-26ff-49ae-beaf-65d58aea13db/mirroring?forum=sqldatabaseengine

If money is an issue, you will likely get much more of a problem from having to buy Enterprise Edition licenses with Software Assurance, than from new hardware. You...

I am not sure SQL server 2012 will like being on Windows 2008, but it is supported. Some features may not be available to you without SQL 2012, but...