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 rename, sp_addserver, sp_dropserver, SQL Server, Windows
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