A couple things: AlwaysOn is Enterprise only. I forgot about that, so your read only replica is going to be core licensed if you go that route.

For replication, it doesn't...

This should help:

SELECT T1.Name AS DatabaseName,

Isnull(Max(T2.recovery_model), 'No Backup Taken') AS recovery_model,

'Log' AS BackupType,

Isnull(CONVERT(VARCHAR(23), CONVERT(DATETIME, Max(T2.backup_finish_date), 131)), '') AS LastBackUpTaken

FROM sys.sysdatabases T1

LEFT...

Miles Neale (2/5/2013)

---

Remember how things work. Bleeding edge -> cutting edge -> early adopters -> the norm -> late bloomers and never made its. There is a cycle....

We've already reported, or at least a few people have. I missed the first practice, but I need to start throwing for sure.

I heard back that you can write powershell scripts to do this, which would make it repeatable, but require development on your part. I'll try to track down a sample...

I'm not sure it does, but it packages things up, so there might be a hack. I'll ask.

Deployment Manager from Red Gate handles some of this. I know there are some open source tools, but I don't know of anything integrated. Since most of these are scriptable,...

gsmith 7350 (2/1/2013)

---

We autochart KPI's on control charts to watch for trends, special causes, etc. . Most of these charts are X-bar with R-charts with control limits calculated to +-...

Mark Stacey (2/1/2013)

---

Averages can be misleading, you could have a server idling for 16 hours, and breaking for 8.

A better technique is to have buckets with how long the server...

Look for backup history for any of the databases. The restore dialog might be the easiest if you haven't done it before.

See if you have options to restore transaction logs.

Thanks, George. I'll add it to my list to look into.

One note, if you have a place you think this should be noted, you can file a documentation bug at...

This might help: http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/07/07/understanding-the-vas-reservation-aka-memtoleave-in-sql-server.aspx

Essentially this is an area of memory for objects that might need it. This is not the buffer pool and data space, but other memory space.

Licensing is bad with MS. They don't have the scenarios well defined, and lots of licensing people aren't up to speed. If you call back, you might get different advice.

I...

I haven't used Avamar, but if the log file is growing, either you have a growing workload that needs more log space, or the log isn't being marked as backed...

Did you use Configuration Maanger to change the service? Check the log for errrors? If it ones for one instance, it has the rights for service start, but it might...