3

Given:

  • a database backup of >100G uncompressed disk space
  • SQL Server 2012 Instance
  • Dev/Test system host (Non-production)

Is it better to restart the MS SQL Server, Agent, etc services after restoring the DB? Why or why not?

  • 1
    There is absolutely no reason for restarting database after restore, you would achieve nothing – Shanky Aug 9 '16 at 1:23
  • generally there are just a few reasons to restart a sql server if you don't have to :) (OS reboot, rebuilt system databses...) – RayofCommand Aug 9 '16 at 14:58
12

There is absolutely no reason to.

Once the database is restored, if over top a previous database or as a new one, there will be no information in cache (or very little). If you were to restart the services, the only thing accomplished is that SQL Server has to run recovery on all of the databases in the instance and re-acquire memory. This would actually cause a detrimental effect, assuming this isn't express edition and the buffer pool is actually being used (i.e. there is more than 1 databases on the system). Even if it were, there is still no good reason to do so.

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.