Script: Shutdown/Restart Sharepoint 2013 and SQL Server

Sometimes I received an error when I access my Sharepoint site at home saying “the server is unavailable”.
I have two options:
1. Restart the Sharepoint 2013 VM
2. Run the script shutdownSQL-SP.cmd

I opted out using #2, the downtime was shorter.  I still have to find the reason why sometimes this error happens.

ECHO ON

net stop “W3SVC” /y
net stop “SPAdminV4” /y
net stop “SPTimerV4” /y
net stop “SPTraceV4” /y
net stop “SPUserCodeV4” /y
net stop “SPWriterV4” /y
net stop “SPSearch4” /y
net stop “OSearch14” /y
net stop “MSSQLSERVER” /y
net stop “SQLSERVERAGENT” /y
net stop “MSSQLFDLauncher” /y
net stop “MSSQLServerOLAPService” /y
net stop “MsDtsServer100” /y
net stop “ReportServer” /y
net stop “SQLWriter” /y
net stop “SQLSERVERAGENT” /y

pause

net start “MSSQLSERVER” /y
net start “SQLSERVERAGENT” /y
net start “MSSQLFDLauncher” /y
net start “MSSQLServerOLAPService” /y
net start “MsDtsServer100” /y
net start “ReportServer” /y
net start “SQLWriter” /y
net start “SQLSERVERAGENT” /y
net start “W3SVC” /y
net start “SPAdminV4” /y
net start “SPTimerV4” /y
net start “SPTraceV4” /y
net start “SPUserCodeV4” /y
net start “SPWriterV4” /y
net start “SPSearch4” /y
net start “OSearch14” /y

PAUSE

Leave a Reply

Your email address will not be published. Required fields are marked *