Category Archives: SQL Server

Script to Rename an SQL Server Instance

Let’s just say either: You have SQL Server installed on an VM that you’re going to clone often You moved a SQL Server intance to a new server You renamed the server that SQL Server is running on In any … Continue reading

Posted in Renaming a Server, SQL Server, scripts | Tagged , , , , | 2 Comments

Finding Which SQL Server Instances Just Restarted

Today, i’m troubleshooting an issue with the cluster where our SharePoint databases are housed. I got an alert from SCOM saying that one of the clustered SQL Server instances had failed. (Thanks SCOM a.k.a. OpsMgr for letting me know!) Anyways, … Continue reading

Posted in troubleshooting | Tagged , , | Leave a comment