winston Smith (11/18/2013)

---

I have a request to audit database usage. Database usage is defined as anytime someone accesses a database for anything, read or write.

I have been looking at...

TheSQLGuru (11/14/2013)

---

Please don't just read a few blog posts, run a few forum questions and then set off doing AGs!!! NOTHING good will come of that! This is...

javirsantos (11/15/2013)

---

The install of the way you show me ¿is it for loss of service?,

As you show me would be:

1. - Passive Node: install SP2 CU1

2. - Balancing cluster with...

Yes it can be, depending on the code in your stored procedures and the volume of data in your database(s).

For example if you have a stored procedure being called 1000...

Yes they can be setup for the account used as the service account, but the best practice is to limit the capabilities of a service account.

The use of a proxy...

The information you have supplied is not particularly clear.

When patching clustered SQL instances the process you should follow is:

1. Patch the passive nodes of the cluster

2. Failover the...

If I am interpreting your post correctly are you saying that you have two physical servers participating in a windows cluster.

On each node you've a SQL server installation you plan...

db808 (10/30/2013)

---

I'm reading the Training Kit Book and there are sections with a "key" icon. What are the relevance of these verses the sections labled "exam hints"

Also is 2...

You really need to post your code for anyone to help with a specific answer.

Not that I have ever restored a database to a network location, I have backed up to a network location so the same principal will apply.

When using UNC paths you...

On the server you are trying to connect your data source to have you checked the SQL log? It will give you a full description of the login failure...

Actually that last statement is partially incorrect, you cannot do it using a maintenance plan as the maintenance plan tools cannot read the database, but you can do it via...

As the database(s) in the DR node are asynchronous it is a non readable secondary and for that reason its not possible to take a backup of the databases. ...

In my experience, you can either add the artciles via the gui in SSMS or use the system stored procedures to add the article(s) to the publication

Once added this will...

I assume that you are running more than 1 instance to be running active \ active.

In that case patch the passive instance on each cluster node first, then failover to...