If I recall with Access it utilizes an ODBC connection to the database. As long as the connection is not using a shared login then you can track individually who...

Include logic in the job to verify if you are running on primary replica or not. You can do this by checking sys.dm_hadr_availability_replica_states and the "is_local" column is set to...

I would utilize Registered Servers within SSMS. If you add all the servers in question, grouping as you see fit [e.g. all development, all production, all staging/QA]. You open a...

Ah did not pay attention to that...

Your...

Just to clarify: SSRS is not cluster aware so it would be treated as a standalone installation. It will not failover to any other node within your cluster. You would...

You want to use the "@i" to select each record of your CRM table and populate each value into a variable so you can then pass it into the send...

You might check the backup history to see what your throughput is for each database, find the worst one and work from there. I modified this from Brent Ozar's script...

I have no clue, that is something you would have to test.

Unless you checked the log_reuse_wait_desc at the time of the error it likely cleared up by the time you got into the office to check it. It was likely just...

I generally only create baseline of alerts for 824 and 825, then 19-25. I have used Glenn Berry's script[/url] at times to create these for me.

Any other alerts outside of...

F. van Ruyven (8/13/2014)

---

I suspect sql2012 (SP 2) of still having a memory leak. We have a daily job (on a test system) that runs fine for about a month...

Doing this is documented in multiple TechNet and MSDN articles and is the same type of process for SQL Server 2005 and onward. A simple Google search for your first...

What is doing the full backup currently being done?

In order to know if you can even do log backups against the database you need to know what recovery model the...

There is no tool that I know of but only references on what general guide to set your max server memory to. Glenn Berry has blog post here[/url] that includes...