SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James' SQL Footprint

Love SQL Server, Love life.

Archives: August 2013

SQL Server 2012 Express installation failed issue

I got an strange error when installing SQL Server 2012 Express

Window Server 2008 R2 Enterprise + SP1
Microsoft Visual Studio 2012 installed
.Net 4.5 framework Installed

When I double clicked SQLEXPRWT_x64_ENU.exe, it just disappeared immediately, no setup window popped up. then I tried
1. unzip the installation code 

Read more

2 comments, 1,640 reads

Posted in James' SQL Footprint on 7 August 2013

Alwayson availability groups failover monitoring - Part 1

There are a lot of ways to monitor AG, sql server errorlog, window event log, cluster log......, here I list another way to check and monitor AG state with the log files below:

1. AlwaysOn Health Diagnostics Log
These files in the SQL Server Log directory have the following format:…

Read more

2 comments, 5,596 reads

Posted in James' SQL Footprint on 4 August 2013