Home » Posts tagged 'SQL 2008'
Tag Archives: SQL 2008
Error While running PowerShell code from SQL Agent job – “Path Does Not Exist”
Issue: When I am running code from PowerShell console its running fine but when I execute it through SQL agent job step, I am getting below error: – The job script encountered the following errors. These errors did not stop the script: A job step received an error at line 14 in a PowerShell script. … Continue reading
SQL Server Cluster LooksAlive and IsAlive Check
Windows Cluster Service use the “heartbeat” process to check whether each node is alive at both the OS level and SQL Server level. Heartbeat signals works on UDP. Microsoft Windows Cluster service perform 2 health checks to perform node & resource availability check. LooksAlive Health Check 1) LooksAlive is a quick lightweight health check 2) … Continue reading
Creation & Deletion of Database Snapshot by SQL Agent Job
Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want to delete the oldest with same frequency. Quite interesting scenario. I did not go in deep why he has such requirement but I am clear that It can be done very easily. So let’s … Continue reading
Renaming or Changing SQL Server Cluster Instance
Renaming or Changing SQL Server cluster instance process is bit different from renaming a stand-alone instance. Refer : Rename or Change SQL Server Standalone Default Instance http://mssqlfun.com/2014/06/30/rename-or-change-sql-server-standalone-default-instance/) Refer : Rename or Change SQL Server Standalone Named Instance (http://mssqlfun.com/2014/07/29/rename-or-change-sql-server-standalone-named-instance/) The name of the virtual server is always the same as the name of the SQL Network … Continue reading
How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?
Steps : How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ? 1) Open SQL Server Installation Center > Click Installation from Left > Click Add node to a SQL Server Failover Cluster from right 2) Click Run to start setup 3) Click Ok to cont., In case of any … Continue reading