3

I have a Sharepoint Farm with some servers.

Our DBA is going to do a planned SQL maintenance and the server that exclusively hosts SQL Server requires to be offline.

What I, as Sharepoint Administrator, need to do before and after this down time?

3

Nothing. SharePoint will throw errors that it cannot connect to its databases while SQL is offline and will reconnect once SQL is back online and the databases are in an Online state.

  • I am insecure about services like Search, UPS and others. So, they will gracefully stop their current operations and then come back? – Guilherme Matheus Costa Apr 25 '17 at 19:11
  • 1
    Yes, they will as long as only the DB servers will be offline. – Mihail-Florin Popa Apr 25 '17 at 19:23
5

I agree with Trevor that you don't have to do anything however, generally if the SQL servers are going to be offline, it's a good idea to shut the SharePoint servers down before SQL goes offline and start them back up after SQL is back online again. This provides a good opportunity to clear any cobwebs from memory while shutting all of SharePoint down gracefully.
If you choose to leave your SharePoint servers running, I would run a check on all SharePoint service apps after the SQL maintenance is done. Service apps will not gracefully stop but instead throw continual errors. If you have environmental monitoring such as SCOM, you'll want to mute alerts for the SharePoint servers or your inbox will be flooded. Lastly, when the databases are up, if something isn't working, like search, you can restart the service app to fix it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.