Thank You Matt. I am using EE and I am planning on setting up AG. I will play around with my test Env and see if it works.

Steve, Thanks for...

When you are using Availability Group set up, you just fail over to your secondary. The secondary becomes the primary and data will be replicated back by itself. So you...

Rightly put Grant.

Now the only question is are you talking about Proc cache or are you talking about tables residing in memory on SQL Server 2014. memory optimized tables?

Since you are using SQL server 2012, you could do the complete set up using HADR. If you are using Log shipping then you have no other option than Back...

If it fails, its no big deal. It is not a critical system. All the information are already in each of your servers. It just makes my job easy to...

So far from my personal use, the pros out weigh the cons. We have been using CMS for a very long time and have not found an issue.

Could it be that the BuildIn adminstrator account is disabled? If I am not mistaken, the buildin administrator account is disabled by default in Windows 7.

There is a job that runs in the Distribution Database that will clean up old snap shots that were created.

If at any time you changed the path of the...

Yes, you can. You can specify which DB you want the metrics for.

Just specify the database_id

There are lots of DMV's that you can use to get these metrics. For instance sys.dm_exec_procedure_stats.

The activity monitor shows these details as well.

If you create the logins with the right SID then you will not have a problem with permissions and roles when restoring the DB.

You can get the SID from...

That worked. I needed to give Permission to the schema. Thats it. Thanks everyone for helping.

I am going to try

GRANT SELECT ON SCHEMA :: abc to abcRole WITH GRANT OPTION

and see if that will work.

I can make it work by giving the Select permission to the role on the other Schema. I dont want to give direct select permission on tables.

That does not work. It gives permission error on the table in the other schema. It works with "Execute as Owner"